Displaying rows of dupe orders with discrepancies..

[Jadanar]

I'm running a report twice of ETAs for deliveries, once on day 1 and once on day 2. Sometimes, an ETA on an order will change from the first report to the second and I need to track these changes. With both of these reports being on a separate page, I'd like it if I could find a way to cross reference page 1 vs page 2, identify if the Order # exists on both pages, compare the ETAs and then if there's a discrepancy to list the ENTIRE row's worth of data for that Order #. I'd prefer if I could have this new set of information displayed on a separate page entirely for easier reviewing.

I was originally experimenting with VLookup as it can display a row's worth of data but it required a reference point and I'd rather this be as automated as possible. I experimented with Index, but couldn't find a way to return the row.. And honestly, I may be approaching this entirely wrong as I'm hardly an experienced Exceller - so any alternate suggestions are more than appreciated as eventually I'd like to get graphs and tables or some sort of summary system on the first page for easy viewing to display the changes in ETAs and possibly locate any patterns.

Thanks in advance for any assistance. =)

[Jadanar]

Attempting to add an example worksheet.

[Jadanar]

After thinking about this further, I'm realizing that as I add more worksheets to the workbook that there'll be no reference point to pull this tidbit of information without constantly needing to update my formula.. So I guess I'm wondering if there's any way to create a formula that will also update with the sheets that are added and instead of comparing sheet 1 to sheet 2, will compare the Order #'s listed on every sheet, with every other sheet that is added going forwards... Hmm =/

[JeteMc]

Hello Jadanar and Welcome to Excel Forum.
See if this might be a consideration. Append the newer data to that in the 1st report sheet. Add a column that will display a new ETA date if different for the original using:

Please Login or Register  to view this content.

Produce a pivot table on the Results sheet and filter by deselecting blanks in the 'New ETA' column.
One thing I can see as a limitation might be the amount of data, since the sample showed only two days worth. The 2013 version has slightly fewer than 1,050,000 rows, however if the data was placed into a Data Model, that has slightly fewer than 2 billion rows. The following article leads me to believe that the data model is available to users of the 2013 version.
Note: view the drop downs for 'File Size Limits' and 'Other Limits'.
https://support.office.com/en-us/art...2-B58778FD68EF
Let us know if you have any questions.