Data Shuttle - Track Changes Difference from Previous Upload


I am using data shuttle to upload data daily. I have track changes on to see the changes that were applied.

However, how can I see what the difference was?

Day 1: 100

Day 2: 102

The difference is 2...but how to see what the change is in a separate column?



  • marc4
    marc4 ✭✭✭✭

    You might be able to do it this way:

    Start with two sheets that have the same data on Day 1.

    Upload the data to one sheet at 1:00am. Then use a formula to show the difference between the cell in the two sheets.

    Upload the data to the second sheet at 11:00pm

    Then start again.