Using Results from Inquire Compare Files to make updates

%3CLINGO-SUB%20id%3D%22lingo-sub-1118486%22%20slang%3D%22en-US%22%3EUsing%20Results%20from%20Inquire%20Compare%20Files%20to%20make%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118486%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Inquire%20add-in%20and%20Compare%20files%20to%20%3CU%3Eidentify%20cell%20value%20changes%3C%2FU%3E%20from%20one%20month%20to%20the%20next.%20(Nov%202019.xlsx%20and%20Dec%202019.xlsx).%20I%20will%20then%20update%20a%20third%20spreadsheet%20(Mydata.xlsx)%20with%20the%20newest%20data%20(found%20in%20Dec%202019).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20results%20show%20Nov%202019%20(top%20left)%20and%20Dec%202019%20(top%20right)%20and%20Results%20(lower%20right).%3C%2FP%3E%3CP%3ENote%3A%20I%20am%20only%20looking%20at%20%22Entered%20Values%20and%20Calculated%20Values%22%20(results%20filter%20lower%20left)%3C%2FP%3E%3CP%3EResults%20Table%20has%20sheet%2C%20Cell%2C%20Value%201%2C%20Value%202%20and%20Change%20Description%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResults%20tell%20me%20Cell%20D2755%20Entered%20Value%20changed%20-%20and%20I%20can%20see%20the%20information%20went%20from%20Blank%20in%20Nov%202019%20to%20having%20a%20value%20in%20Dec%202019.%26nbsp%3B%20%26nbsp%3BThe%20top%20two%20quadrants%20seem%20to%20be%20showing%20the%20correct%20Nov%20%26amp%3B%20Dec%20rows%20-%20but%20I%20notice%20there%20are%20more%20cells%20than%20D2755%20that%20changed.%20They%20are%20not%20in%20the%20Results%20table%20-%20but%20they%20are%20highlighted%20in%20the%20Dec%202019%20-%20where%20the%20data%20was%20entered.%26nbsp%3B%20%3CSTRONG%3EIs%20this%20expected%20behavior%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22arial%2Chelvetica%2Csans-serif%22%3EAs%20far%20as%20using%20the%20information%20to%20make%20my%20changes%20to%20Mydata.xlsx%20-%20what%20is%20the%20best%20approach%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E(I%20can%20certainly%20write%20formulas%20to%20compare%2Fupdate%20-%20but%20I%20feel%20like%20I%20must%20be%20not%20understanding%20some%20of%20the%20Compare%20Files%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3ESheryl%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20-%20looks%20like%20you%20have%20posted%20on%20using%20Inquire%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1118486%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1122222%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Results%20from%20Inquire%20Compare%20Files%20to%20make%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122222%22%20slang%3D%22en-US%22%3EPerhaps%20it%20does%20highlight%20cells%20which%20have%20been%20marked%20with%20a%20change%20but%20you%20have%20unchecked%20that%20type%20of%20change%20in%20the%20options%3F%3C%2FLINGO-BODY%3E
New Contributor

I am using Inquire add-in and Compare files to identify cell value changes from one month to the next. (Nov 2019.xlsx and Dec 2019.xlsx). I will then update a third spreadsheet (Mydata.xlsx) with the newest data (found in Dec 2019).  

The results show Nov 2019 (top left) and Dec 2019 (top right) and Results (lower right).

Note: I am only looking at "Entered Values and Calculated Values" (results filter lower left)

Results Table has sheet, Cell, Value 1, Value 2 and Change Description

 

Results tell me Cell D2755 Entered Value changed - and I can see the information went from Blank in Nov 2019 to having a value in Dec 2019.   The top two quadrants seem to be showing the correct Nov & Dec rows - but I notice there are more cells than D2755 that changed. They are not in the Results table - but they are highlighted in the Dec 2019 - where the data was entered.  Is this expected behavior?

As far as using the information to make my changes to Mydata.xlsx - what is the best approach?

(I can certainly write formulas to compare/update - but I feel like I must be not understanding some of the Compare Files functionality.

 

Thank you in advance for your help.

Sheryl

 

@Sergei Baklan - looks like you have posted on using Inquire

1 Reply
Perhaps it does highlight cells which have been marked with a change but you have unchecked that type of change in the options?