| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help, My job may depend on it!!!
if the format is the same for the quarter sheets as it is for the master sheet
on each quarters sheet, enter an = in cell A1 (Or A2) and without hitting enter go to the mater sheet and select the top left cell for that quarter. on the quarter sheet then, copy the first cell to as many other cells as needed. "Kev" wrote: Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March. So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4? Im sure its easy but i have really searched. Please help me. Thanks already, Kev. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto run macro depend on cell value | Excel Worksheet Functions | |||
| How can I have have one column's input depend on the variables in a second one? | Excel Worksheet Functions | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
| How to show data from other sheet depend on value?? | Excel Worksheet Functions | |||
Threaded Mode
