What you describe is possible; however, if you ever need to summarize or
analyze this data, you will need to perform mammoth data transformations to
be able to summarize/analyze. I would encourage you to re-think your set up.

You say you have 366 columns. Excel 2007, eh? How many rows of data?

To answer your question,

Go to the Q1 tab.
In the top left cell where you want data to appear type an equals sign
Click on the 2007 tab and select the top left cell whose data you want
Press the F4 function key until the dollar signs disappear
Press the Enter key
Now copy that formula to all the rows and columns you want for Q1
Repeat for Q2 through Q4

"Kev" wrote:

Thanks for response, i will explain. My Excel schedule runs 366 columns on
one sheet. At the bottom of that sheet i have tabs marked sheet 2, sheet 3
sheet 4 etc. I have relabelled them 2007(the original), 2007 Q1, 2007 Q2,
2007 Q3, 2007 Q4.
I am hoping that by clicking on the now Q1 tab a sheet will appear
displaying just the first 93 columns of sheet 1(2007) and the sheet 2 tab the
columns 94 - 186 etc?
Therefore as i input data on the 2007 sheet when i finish my not so bright
boss can click on Q3 and just see the data from columns 187 - 278 july - sept.

I have a feeling im explaining this badly.

"Bernard Liengme" wrote:

Question is unclear.
What do you mean by 'tab' - the actual sheet's tab and you want to change
its name? or are you misusing 'tab' for 'worksheet'?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kev" wrote in message
...
Please help, I have a 365 day schedule and want tab 1 to show Q1 Jan -
March.
So any data changed on sheet one the full year will be reflected in sheets
1
- 4 labelled Q1 - Q4?
Im sure its easy but i have really searched.
Please help me.
Kev.