MS Excel Macro to compare data (data in MS Access)
This project has been awarded to mrbrave for $30 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
So the aim of the project is testing. I have values in attached excel which needs to be verified (tested) against respective values sitting in the access database (attached).
Following are the requirements:
1) Be able to run a macro which will pull data from access database and populate excel sheet (blank table). Use of sql in macro is must ... and population of each cell in excel blank table should be based on periods (which will be read from excel period headings ex: Jan-12, Mar-12 etc.) So the sql query should be passed the period read from the excel sheet. This is so if I change periods in excel (ex: if Jan-13 is changed to Dec-12) excel blank table should be populated based on new period value.
2) Once excel blank sheet is populated with data, then do a compare and the values that don't match in the original excel table should be flagged ref (cell color fill read will work).
3) I have additional values in access db (those periods dont exist in excel table), these additional values should not be populated as they are not relevant.
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