En cours

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

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é à :

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 en 1 jour
(1 Commentaire)
2.5

9 freelance ont fait une offre moyenne de 43 $ pour ce travail

Teloquence

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

50 $ USD en 1 jour
(50 Commentaires)
5.2
proauthor

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

54 $ USD en 0 jours
(13 Commentaires)
4.2
vikashgadia

excel expert for ur project

45 $ USD en 3 jours
(15 Commentaires)
3.6
Solver86

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

35 $ USD en 1 jour
(7 Commentaires)
3.3
decato0110

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

30 $ USD en 3 jours
(6 Commentaires)
2.1
creatdesign

~ Will Provide Service Until U Satisfy 100% ~

45 $ USD en 2 jours
(5 Commentaires)
1.8
hlozada

I may do this.

50 $ USD en 3 jours
(0 Commentaires)
0.0
sknadeem123

ready to start sir .

35 $ USD en 1 jour
(0 Commentaires)
0.0
zaiffi

Consider it done in hours

35 $ USD en 1 jour
(0 Commentaires)
0.0