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
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