Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-capture data that changes daily
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-capture data that changes daily
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Auto updating pivot tables using external XML data | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |