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