Verildi

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

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

Beceriler: Excel

Daha fazlasını görün: data compare access, pull data, fill excel sheet, excel verified, excel ex, database population, data in, compare exist, excel access table, excel macro match data, access query table, excel project use database, data compare, access query excel, excel read cell value, excel additional, macro population excel, excel sql query, ref data, project macro, excel 2013 macro, access table query, excel color cell, access testing, macro cell value

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #4407646

14 freelancer bu iş için ortalamada 92$ teklif veriyor

mrbrave

A easy and quick project for experienced developer....I have done more complex work then this in past....See message box for working demo.

1 gün içinde 30$ USD
(67 Değerlendirme)
5.3
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

in 2 gün içinde95$ USD
(15 Değerlendirme)
4.9
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

in 7 gün içinde250$ USD
(7 Değerlendirme)
4.7
amcsummers

Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person yo Daha fazlası

in 3 gün içinde80$ USD
(20 Değerlendirme)
4.0
vikashgadia

lets start ur project

1 gün içinde 44$ USD
(14 Değerlendirme)
3.5
vickkey7

I am ready to start this project...... thanks

in 5 gün içinde198$ USD
(9 Değerlendirme)
3.4
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi Daha fazlası

in 5 gün içinde50$ USD
(3 Değerlendirme)
2.6
srdas2012

Hi We have Done Exactly similar Programme Please see PMB

in 3 gün içinde74$ USD
(2 Değerlendirme)
2.1
exopad

Hi, Nice project. I can do this for you by using > 10 years Excel/Access programming experience. Ready to start today and able to deliver tomorrow. Thanks, Exopad

1 gün içinde 66$ USD
(2 Değerlendirme)
1.7
soikaushik2013

Hello, I'm interested in your project. Please check PMB. Thanks

in 5 gün içinde50$ USD
(1 Değerlendirme)
1.6
hvkaushi

I can do this.........

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
sylvestermolina

Ready to work on this

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0
sundeepsai17

I have worked a similar project earlier. Please find a demo of my work which compares to sheets and reports are distrabancies in another sheet

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
almirr

Let's do it

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
outstanding123

Excellent VBA Skills,Ready to start work

in 3 gün içinde110$ USD
(0 Değerlendirme)
0.0