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.
This project was awarded to
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Mesa, United States
I have spent the last past 19 years working in the Information Services sector. My mission has been to educate myself in all aspects of computer programming. I have been working exclusively with SQL Server 2000-2008, PL/SQL, VB, VBA, Excel, Access, and HTML over the past 12 years. I am currently attending school to complete my web development degree. I am an enthusiastic employee that strives for perfection and enjoy challenging atmospheres.
Excellent competency.I will ensure project is delivered with 100% Satisfaction of customer
Novi Travnik, Bosnia and Herzegovina
## BIO I am IT worker in office
I am a Computer science graduate. I have more than 5 yrs of work experience on Excel sheets, macros and VB.
Taxila Cantt, Pakistan
Web, Bots, Crawlers, and Scrapers Development. I have expertise in automation services and I can automate any manual process.
Myself a dedicated freelance software professional. I try to solve our customer problem with utmost care. Customer is my top-most priority. I try to provide solutions to my customer at the lowest cost with no compromise on quality.
TILBURG, United Kingdom
More than 15 year use-experience and over 10 year VBA experience
ITS MY PASSION TO WORK IN EXCEL. WE CAN DO ANY THING AND EVERY THING IN EXCEL.. WE CAN GUARANTEE THE FASTEST DELIVERY OF YOUR PROJECT OTHER WE WILL TAKE ONLY FREELANCER'S COMMISSION FOR THE PROJECT. APPLICATION DEVELOPED ARE EMAILING FROM EXCEL. SMS FROM EXCEL TRANSFERRING DATA TO SERVER FROM EXCEL. PDF CREATION CERTIFICATE PRINTING. INVENTORY INVOICING SALEFORCE ETC..
We are experts in VB.net, VB, VB6, C#, ASP.Net, Visual Foxpro Programming, Back End Access, SQL, MySQL, XML, Excel, CSV with more than 10 Years of experience. We have expertise in Multimedia graphics Programmes for Maya (3d Modelling,Animation), 3d Max ,Z-Brush and Photo shop with more than 10 Years of experience. We have experts & professional translators in Hindi, Bengali, Tamil from & to English. Our motto for every customer/client/project is importance, delivery and maintaining High Quality Standard in the shortest time Possible.
Expert VBA Developer VB.net Developer PHP developer