Merge two xlsx files with differences/new data highlighted

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

Compétences : Traitement de Données, Excel

en voir plus : merge xlsx files, sorted data set, sorted data, script sheets, example of number problem with solution, c# get excel cell comment, xlsx, pull data, merge data, medical data, data merge, alignment sheet, excel macro add, csv merge, differences, excel macro row, excel macro csv, excel macro comment, patient files, files missing, macro merge rows, workbook csv, missing columns data, excel 2013 macro, csv files processing

Concernant l'employeur :
( 37 commentaires ) colorado springs, United States

Nº du projet : #4487485

Décerné à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(1 Évaluation)

9 freelance font une offre moyenne de $43 pour ce travail


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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(50 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(13 Commentaires)

excel expert for ur project

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)

**** I will code a VBA macro in 1 hour from now. It's an easy task. Thanks ****

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)

~ Will Provide Service Until U Satisfy 100% ~

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)

I may do this.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

ready to start sir .

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Consider it done in hours

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)