Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing archived data
I have a workbook that starts with two worksheets. Sheet 1 is a time sheet
and sheet 2 a list of employees. A drop down list from sheet 2 populates the cells in sheet 1. Sheet 2 contains formula regarding the number of shifts recorded in sheet 1. I have recorded a macro that creates a new sheet and archives the sheet 1 data leaving it clear for the next period. The new sheet is named after a cell in sheet 1 i.e. the date. I am looking for a way to view an achieved page using the sheet 2 formulas without loosing information on sheet 1. Does this make sense? Wobbly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Delete Archived TMP Files | Excel Discussion (Misc queries) | |||
How to delete archived tmp files | Excel Discussion (Misc queries) | |||
What program should i use for archived files? | Excel Discussion (Misc queries) | |||
Can't change an archived document | Excel Discussion (Misc queries) | |||
Formula to give archived name | Excel Worksheet Functions |