Home

compare two spreadsheets (merge if possible)

%3CLINGO-SUB%20id%3D%22lingo-sub-196983%22%20slang%3D%22en-US%22%3Ecompare%20two%20spreadsheets%20(merge%20if%20possible)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20432px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34736i347327C817316225%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture1.PNG%22%20title%3D%22Capture1.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eworkbook%20january%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20448px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34738i97662A3478D10298%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20receive%20a%20file%20each%20month%20with%20a%20list%20of%20patients%20and%20what%20preventative%20services%20are%20due.%26nbsp%3B%20I%20change%20the%20cell%20color%20of%20the%20x%20cells%20to%20green%20when%20I%20have%20completed%20them.%26nbsp%3B%20next%20month%20I%20will%20receive%20a%20file%20and%20I%20would%20like%20to%20see%20the%20differences%20of%20what%20they%20needed%20this%20month%20versus%20last%20month%20that%20I%20may%20have%20already%20done%20but%20the%20company%20did%20not%20receive%20the%20service%20yet.%26nbsp%3B%20there%20can%20be%20patients%20added%20or%20taken%20off%20each%20file%20and%20I%20would%20like%20to%20see%20the%20differences%20and%2For%20merge%20so%20that%20I%20do%20not%20duplicate%20work%20I%20have%20already%20done.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3A%26nbsp%3B%20last%20month%20jill%20smith%20needed%20a%20bmi%20and%20a%20colon%2C%20I%20completed%20the%20bmi%20(which%20is%20why%20it%20is%20green)%20and%20submitted%20to%20the%20insurance%20company.%3C%2FP%3E%3CP%3Ethe%20current%20report%20shows%20jill%20smith%20needing%26nbsp%3B%20bmi%20(which%20I%20have%20already%20completed%20last%20month%20but%20they%20did%20not%20receive%20in%20time%20to%20update)%20%2C%20a%20mammogram%20(wasn't%20needed%20last%20month%20so%20wasn't%20completed)%2C%20and%20a%20colon%20(I%20did%20not%20complete%20last%20month%2C%20which%20is%20why%20it%20was%20not%20colored%20green%20in%20last%20month's%20spreadsheet%20and%20remains%20on%20it%20this%20month)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20need%20to%20submit%20the%20bmi%20again%20since%20I%20have%20already%20done%20it%20so%20I%20would%20like%20that%20to%20be%20green%20on%20the%20current%20months%20report.%26nbsp%3B%20new%20patient%20rows%20would%20have%20to%20be%20added%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20is%20the%20easiest%20way%20to%20accomplish%20this%3F%26nbsp%3B%20I%20have%20excel%2016%20(but%20I%20cannot%20find%20inquire%20or%20compare%20on%20my%20ribbon%20or%20in%20the%20addins)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-196983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310111%22%20slang%3D%22en-US%22%3ERe%3A%20compare%20two%20spreadsheets%20(merge%20if%20possible)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310111%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20Synkronizer%20Excel%20Add-in%20for%20Compare%20Two%20Spreadsheets%2C%20Also%20you%20can%20Merge%20Multiple%20Excel%20Files%20using%20this%20Excel%20Add-in.%3C%2FP%3E%3CP%3ECheck%20Features%20-%20%3CA%20href%3D%22https%3A%2F%2Fwww.synkronizer.com%2Fcompare-excel-tables-features%2Fcompare%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.synkronizer.com%2Fcompare-excel-tables-features%2Fcompare%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197387%22%20slang%3D%22en-US%22%3ERe%3A%20compare%20two%20spreadsheets%20(merge%20if%20possible)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197387%22%20slang%3D%22en-US%22%3Eapologies%20i%20did%20not%20read%20your%20original%20post%20properly!%20Inquire%20is%20only%20available%20in%20the%20Office%20Professional%20Plus%20and%20Office%20365%20Professional%20Plus%20editions%2C%20are%20you%20running%20either%20of%20these%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197252%22%20slang%3D%22en-US%22%3ERe%3A%20compare%20two%20spreadsheets%20(merge%20if%20possible)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197252%22%20slang%3D%22en-US%22%3EI%20do%20not%20have%20this%20option%20under%20the%20manage%20com%20addins%2C%20as%20mentioned%20above.%20hopefully%20someone%20can%20chime%20in%3A)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197068%22%20slang%3D%22en-US%22%3ERe%3A%20compare%20two%20spreadsheets%20(merge%20if%20possible)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197068%22%20slang%3D%22en-US%22%3EI%20cannot%20give%20you%20the%20answer%20to%20the%20easiest%20way%2C%20but%20to%20turn%20on%20inquire%2C%20Go%20File%2C%20Options%2C%20Add-ins%2C%20then%20at%20the%20bottom%20switch%20Manage%20to%20Com%20Add-ins%20and%20you%20can%20enable%20inquire%20there.%20Good%20luck%20with%20an%20easier%20option%2C%20i%20am%20sure%20someone%20on%20here%20will%20have%20the%20answer.%3C%2FLINGO-BODY%3E
Highlighted
bridgetbrown1971
New Contributor

workbook januaryworkbook january

Capture.PNG

I receive a file each month with a list of patients and what preventative services are due.  I change the cell color of the x cells to green when I have completed them.  next month I will receive a file and I would like to see the differences of what they needed this month versus last month that I may have already done but the company did not receive the service yet.  there can be patients added or taken off each file and I would like to see the differences and/or merge so that I do not duplicate work I have already done.  

 

example:  last month jill smith needed a bmi and a colon, I completed the bmi (which is why it is green) and submitted to the insurance company.

the current report shows jill smith needing  bmi (which I have already completed last month but they did not receive in time to update) , a mammogram (wasn't needed last month so wasn't completed), and a colon (I did not complete last month, which is why it was not colored green in last month's spreadsheet and remains on it this month)

 

I do not need to submit the bmi again since I have already done it so I would like that to be green on the current months report.  new patient rows would have to be added as well.

 

what is the easiest way to accomplish this?  I have excel 16 (but I cannot find inquire or compare on my ribbon or in the addins)

4 Replies
Highlighted
I cannot give you the answer to the easiest way, but to turn on inquire, Go File, Options, Add-ins, then at the bottom switch Manage to Com Add-ins and you can enable inquire there. Good luck with an easier option, i am sure someone on here will have the answer.
Highlighted
I do not have this option under the manage com addins, as mentioned above. hopefully someone can chime in:)
Highlighted
apologies i did not read your original post properly! Inquire is only available in the Office Professional Plus and Office 365 Professional Plus editions, are you running either of these?
Highlighted

Try Synkronizer Excel Add-in for Compare Two Spreadsheets, Also you can Merge Multiple Excel Files using this Excel Add-in.

Check Features - https://www.synkronizer.com/compare-excel-tables-features/compare

Related Conversations
spreadsheets
jsam1_ in Excel on
1 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies