Data Shuttle - Track Changes Difference from Previous Upload

Anthony G

Hello,

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

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.

/marc