Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A table gets updated every day, I want to take a snap shot of each
I import data from Lotus Notes into an Excel 2007 table through a link. I use
many COUNTIF statements to give me a count of records with certain criteria. I want to copy the count results into another worksheet to track that days results. The next day, I refresh the data and it calculates new counts. I now want to take a snapshot of that days counts and log them in the worksheet. This will happen day after day so that I can chart a trend. My problem is, I can't figure out how to make a running log of the counts day after day, when I refresh the same data table each day. I want to automate the log. Anyone ever done this before and can give me some hints. Assuming a worksheet with a list of dates (Jan 1 through Dec 31) in A1 through A365. Column B contains the following formula: IF(A1=TODAY(),data_cell_reference,""), but if I do this, the previous day's calculation will blank out the data. I want the data from the previous days snapshot to remain. Other attempts I've tried create a circular reference. -- TClawson Project Management |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a excel table in Power point that is updated alone? | Excel Discussion (Misc queries) | |||
Dynamic Table Should Always Maintain Borders When Data Is Updated | Excel Discussion (Misc queries) | |||
How to keep updated table of data ? | Excel Discussion (Misc queries) | |||
Disappearing Data Items on Pivot Table -Updated Question | Excel Discussion (Misc queries) | |||
multiple pivots updated with selection in one table | Excel Worksheet Functions |