Home |
Search |
Today's Posts |
#1
|
|||
|
|||
synchronizing mutiple sheets to mirror the previous data
Imagine having a workbook with 31 worksheets representing the days of a month. "Day 1's" data sets the standard/format for "Day 2's" data, and "Day 2's" data sets the standard/format for "Day 3's" data.... and so on.
If I make a change to one particular day, I need all proceeding days or sheets to change / mirror the sheet being edited. It is important that the previous sheet's data remains unchanged. To make things a little more tough, some of the data on the sheets are color coded with the fill tool. This will be changed periodically but must be mirrored to the sheet being edited too and carry over to the upcomming days. Please help me! How can this be done? Thanks! Rick :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running mutiple excel sheets on mutiple computers | Excel Discussion (Misc queries) | |||
Sumif across mutiple sheets | Excel Worksheet Functions | |||
Mutiple Spread Sheets | Excel Worksheet Functions | |||
Repost:Synchronizing two sheets within the same workbook | Excel Discussion (Misc queries) | |||
Synchronizing two sheets within the same workbook | Excel Discussion (Misc queries) |