How do i get sheet 2 to show a specific section of sheet 1?Please
 

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.

How do i get sheet 2 to show a specific section of sheet 1?Please
 

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.

How do i get sheet 2 to show a specific section of sheet 1?Ple
 

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.

How do i get sheet 2 to show a specific section of sheet 1?Ple
 

See if this works for you on a new workbook first
On Sheet1, in row I enter the numbers 1,2,3,4 .... up to 366 (this is in
Cell NB1)
You need enter only 1,2,3 and drag to fill the other cells
On Sheet2 (It does not matter what it is called) enter =Sheet1!A1
Click the fill handle of A1 (the small solid square in lower right cornet);
drag to CO1
This gives formulas =Sheet1A1, =Sheet1!B1...... =Sheet1!CO1
On Sheet3 (It does not matter what it is called) enter =Sheet1!CP1
Click the fill handle of A1 (the small solid square in lower right cornet);
drag to CO1
This gives formulas =Sheet1CP1, =Sheet1!CQ1...... =Sheet1!DG1

Do you see the pattern? Sheet2 show the first 93 cells of row 1 in Sheet2
Sheet3 shows cells 94 to 186

Using R1C1 formulas might make it easier to do but harder to explain!

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kev" wrote in message
...
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.

How do i get sheet 2 to show a specific section of sheet 1?Ple
 

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.