View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.