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.
13 freelancers are bidding on average $127 for this job
Hi. I am Usman and I shall be able to design a VBA macro based Excel sheet according to mentioned specifications. All the three objectives shall be implemented. Please discuss before awarding the work. Regards.
Hi, I am good at excel and macros. I will produce the results with great accuracy. Can you please give permission to discuss further on this to star the work. Looking forward for your reply.