comparing two sheets of data

**13lack13lade** · 04-13-2014, 08:40 PM

Hi All,

Not sure if this should be in VBA or Formulas however what im trying to achieve:

I have a data report that i pull today, tomorrow i want to run the same report and see if there are any differences on the report. e.g show data that was not on the previous report.

Id imagine id have a sheet with yesterdays data, sheet with todays data, sheet with Differences that only shows the new lines between the report. Then after i have done i would just create a macro clear the difference sheet so its blank, copy todays data over to yesterdays data and repeat the process daily.

What is the easiest way to do this? im getting stuck on the comparing..

**13lack13lade** · 04-13-2014, 08:57 PM

Will use vlookup then filter #N/A to obtain new values, if anyone has a better way please advise. thank you!

**FDibbins** · 04-13-2014, 09:05 PM

You can probably do this with a vlookup() or index/match function, and, instead of a macro to delete/copy etc, you could just switch between sheets for each new day