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.