Excel VBA for Excel document created
Budget: $10 – $75 USD
Excel VBA Developer Needed to Create Macros
I'm a school employee.
I have an Excel document that's already created with multiple worksheets. The yellow is the part that information will be pulled from two other workbooks to this Excel document. I'll enter a date range and in the two books it's to look for any postings that have that date and column c. And also needs to take into account column d (for this column it has to be able to read lowercase and uppercase) for which worksheet it goes on. It will then return the information for that date or dates.
There will be a personal workbook and a real estate workbook.
The real estate book can have partial pays which would go on the last two worksheets. The second to last one has the newest ones on it only. The very last one has every single partial pay on it that fell into the date ranges prior and continuing forward.
I have all the cells locked that does not need any attention from you.
Tasks:
- Develop VBA code to automate processes in Excel
- Create macros to streamline data entry and generate reports
Requirements:
- Proficiency in Excel VBA development
- Experience in creating macros and automating tasks in Excel
- Ability to work with complex formulas
Additional Information:
- No worksheet or cell protection required
- VBA code should be commented for ease of understanding and future modifications
I'm a school employee.
I have an Excel document that's already created with multiple worksheets. The yellow is the part that information will be pulled from two other workbooks to this Excel document. I'll enter a date range and in the two books it's to look for any postings that have that date and column c. And also needs to take into account column d (for this column it has to be able to read lowercase and uppercase) for which worksheet it goes on. It will then return the information for that date or dates.
There will be a personal workbook and a real estate workbook.
The real estate book can have partial pays which would go on the last two worksheets. The second to last one has the newest ones on it only. The very last one has every single partial pay on it that fell into the date ranges prior and continuing forward.
I have all the cells locked that does not need any attention from you.
Tasks:
- Develop VBA code to automate processes in Excel
- Create macros to streamline data entry and generate reports
Requirements:
- Proficiency in Excel VBA development
- Experience in creating macros and automating tasks in Excel
- Ability to work with complex formulas
Additional Information:
- No worksheet or cell protection required
- VBA code should be commented for ease of understanding and future modifications