Forum Discussion

Copper Contributor

May 08, 2018

Need help tracking changes in data between two pivot tables

Hey Gurus, I need some help on a report I am creating for a client. I have a pivot table I update with fresh data from my factory every morning and I want to track which orders have new shipping dates...

Formulas and Functions

Macros and VBA

office 365

Wyn Hopkins

MVP

May 09, 2018

Hi

Does your source data contain the old shipping date? or does your refresh replace the shipping data?

Noe Lemus-Diaz
Copper Contributor
May 09, 2018
Hi Wyn, My source data replaces the shipping data if were updated if not it stays the same since the source data is coming straight from my ERP system that the factory does their updates on.
- Wyn Hopkins
  MVP
  May 11, 2018
  So it sounds like you need to copy paste the original data as a comparison before refreshing.
  
  Then you can add a lookup formula (VLOOKUP or INDEX MATCH) based on Order number to compare the dates. Have you used either of those formula before?