Merge two xlsx files with differences/new data highlighted

Completed Posted May 3, 2013 Paid on delivery
Completed Paid on delivery

I pull data sets from a DB application as .xlsx or csv files with medical data. I pull one set and make comments to the sheet where there is missing or problem data. My comments are made in a dedicated comments column which I add to the original data. When I get updated versions of the same dataset I want to be able to merge the new data with the old one, such that my comments are retained, any changes to the old data are highlighted, and new lines and new cell values added to or modifying old data are highlighted. Similar to a diffmerge or windiff result, but retaining the native spreadsheet environment. The number of columns will always be the same but the number of rows will differ, with new rows being added at any position in the sheet. The solution should not "break" the row alignment of my comments causing me to have to paste all my comments over or manually figure out which ones had a comment and which ones did not. I would prefer a script or macro for this so that I can use it on more than one machine, but anything goes. I need this ASAP, today if possible!! Thanks!

Note: There may be several empty rows, there may be empty cells. Sheets should be sorted by 1. Patient Number and then 2. Start Date. The first row are the column headers. Example sheets attached as a single workbook, if we need

Data Processing Excel

Project ID: #4487485

About the project

8 proposals Remote project Active May 3, 2013

Awarded to:

SCRdataPro

Hi, as managment accountant and business intelligence consultant these kind of problems are my daily business. Please see my PM for a proposal on how to solve this easily. Kind Regards, Nico Vondegracht

$45 USD in 1 day
(6 Reviews)
4.0

8 freelancers are bidding on average $42 for this job

Teloquence

Consider it done. Check your PM for my bid details.

$50 USD in 1 day
(333 Reviews)
7.8
sknadeem123

ready to start sir .

$35 USD in 1 day
(78 Reviews)
6.4
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$54 USD in 0 days
(30 Reviews)
4.7
vikashgadia

excel expert for ur project

$45 USD in 3 days
(15 Reviews)
3.8
decato0110

hi, i'm an excel expert, i can do this job quickly, thanks, tristan

$30 USD in 3 days
(13 Reviews)
2.9
creatdesign

~ Will Provide Service Until U Satisfy 100% ~

$45 USD in 2 days
(5 Reviews)
1.8
zaiffi

Consider it done in hours

$35 USD in 1 day
(0 Reviews)
0.0