Excel Macro VBA reconciliation spreadseet
This project was awarded to fedalal2 for $100 USD.Get free quotes for a project like this
We are looking for a person who is able to write a simple VBA Excel macro.
We are accountants and would like to use a VBA macro to reconcile Purchase Day Book (all business expenses that have a receipt) to a payments made through the business bank account/s. Identify which expense receipts were paid through business bank account and which ones were paid using different payment methods. But we only interested to find all payments made through the bank account to which a correspondence entry has been recorded in the Purchase Day Book.
What the macro should do:
First objective: the macro must be able to identify the identical data (numerical values) in a column L of the worksheet PDB (see attached file) with a facility to exclude some rows (this sample would be rows 98-101 and 361-364) to a data in a column F on the worksheet BANK 1, also with a facility to exclude some rows (not in this example). Facility to change columns which are required to run macros must be incorporated in the VBA macro as on different spreadsheets column will be different to the example given to you.
Second objective: once the identical data in the required columns in both worksheets has been identified, the identified data in each worksheet the data should be replicated in the custom indicated columns. In the attached file after running macros PDB column K MUST Equal column L in the BANK 1 worksheet.
Since expense allocation to different columns is automated (see sorting column O), rather than replicating data in the L column, macro should just have a facility just to write required column number in the Sort Column O. User should be able to tell macro which number to write in the sort column.
Third objective: identified and allocated data on the two separate worksheets should be within 30 days period (data column A always A on all our spreadsheets) is included in the worksheet to each entry. If time lapse is more than 30 days but data is identical, then the cell with the data should be filled with let say RED colour. Ideally, the macro should have a facility to adjust time gap settings manually.
That pretty much it.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online