MS Excel Macro to compare data (data in MS Access)

AWARDED
Bids
15
Avg Bid (USD)
$95
Project Budget (USD)
$30 - $250

Project Description:
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.


Thanks

Skills required:
Excel
Additional Files: Project.xlsx DB1.accdb
Hire asadabidi
Project posted by:
asadabidi United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire mrbrave
$ 30
in 1 days
$ 95
in 2 days
$ 250
in 7 days
Hire amcsummers
$ 80
in 3 days
$ 44
in 1 days
$ 198
in 5 days
Hire KellogITSolution
$ 50
in 5 days
$ 74
in 3 days
Hire exopad
$ 66
in 1 days
$ 50
in 5 days