I have a suite of reports driven by daily bottom line numbers. One of
these numbers is an aged backlog, which is fine for today however
retrospectively does not work (Log is updated with no audit trail)

Due to this I have recreated the log to work retrospectivley i.e. by
entering a date the report will generate all my aged backlogs correct
for that day. The resulting data for that date is a simple range.

What I'd like to do to automate the creation of this data quickly is to
have a macro which starts on the date my data begins (01/04/03), copies
the range, pastes as values into a separate sheet (next blank cell
down), then loops by incrementing the date, until date equals todays
date.


Any assistance would be most appreciated

Steve S


---
Message posted from http://www.ExcelForum.com/