The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I want to use an excel workbook with 2 sheets as follows:
Contain Book records of :Number, Source, Type, Date, Reference, Amount,Status
The info on this first sheet is to be compared to:
Contains: Number, Source, Type, Date, Reference, Amount, Status
These are the headers for each sheet. The Book/Bank label only shows the source of the data (whether it came from the company Book or the Bank Statement). The Column with the header "Status" will be used to indicate if the item was determined as a CLEARED item (an EXACT match in both sheets) OR "N/A" IF THERE IS NO MATCH after comparing the 2 sheets...
Below these headers are data that need to be compared (ns comprising anywhere from 100 items to several hundreds.from 100 items to 2000)
I want you to create a Visual Basic Macro (for Excel 2007) that would perform a loop to COMPARE the information in BOOK tab against similar info on the BANK STATEMENT (This is a BANK RECONCILIATION).
The source column will indi...
Sign in or Register to see more