In one workbook, I have several MS Queries automatically import external data
that collects sales data. I have several associated pivot tables that I
update by a macro. In a second workbook, I created a table to get the daily
total, and another table to calculate a month-to-date running total. All
with the push of a couple of buttons to eliminate data entry errors.

How do I generate a daily value, and transfer (capture) that to the correct
cell in a separate daily table, and not have it change when I run the same
report the next day? I have really tried to solve this, and the harder i
try it seems the simpler the answer.
--
SJC

I recommend you switch to MS Access for something like this.

In MS Excel, you could get away with this by creating a link (hit "=" sign
then click on cell reference where total on other page is located - add in $
signs to make it a fixed reference if possible) then creating a macro on your
daily table that copies this formula down one cell then goes back up a cell
and copies and paste specials the previous days formula with value then goes
back to the original table and clears the data so you don't pick up the same
day twice.

"SJC" wrote:

In one workbook, I have several MS Queries automatically import external data
that collects sales data. I have several associated pivot tables that I
update by a macro. In a second workbook, I created a table to get the daily
total, and another table to calculate a month-to-date running total. All
with the push of a couple of buttons to eliminate data entry errors.

How do I generate a daily value, and transfer (capture) that to the correct
cell in a separate daily table, and not have it change when I run the same
report the next day? I have really tried to solve this, and the harder i
try it seems the simpler the answer.
--
SJC