Excel Help!!
 

How can I change the tab but keep the row and column constant when filling in
equations?

I'm orgainizing a excel spreadsheet in which I have many sheets/tabs in.
I'm trying to put a formula in on my main page where I can get the data from
many different sheets while keeping my column and row constant on each page.
I'm trying to do this so I can drag this down and it will automatically
switch pages and while keeping column and roc constant. Example, my main
tab/sheet is labeled "MIKE" and I want to put information from many different
tabs/sheets in column "I" on the main page. Right now I've got the formula
='001'!$l$46...and when I drag it down I want it to pick up sheet '002'!$l$46
for the next line, '003'!$l$46 for the line after...etc. Is there anyway I
can do that?? If someone could help me out I'd greatly appreciate.

Excel Help!!
 

As responsed in .worksheet.functions
(Pl do not multi-post)

='001'!$I$46...and when I drag it down I want it to pick up sheet '002'!$I$46
for the next line, '003'!$I$46 for the line after...etc.

One way ..

Use: =INDIRECT("'00"&ROW(A1)&"'!I46")
and copy down

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MG" wrote:
How can I change the tab but keep the row and column constant when filling in
equations?

I'm orgainizing a excel spreadsheet in which I have many sheets/tabs in.
I'm trying to put a formula in on my main page where I can get the data from
many different sheets while keeping my column and row constant on each page.
I'm trying to do this so I can drag this down and it will automatically
switch pages and while keeping column and roc constant. Example, my main
tab/sheet is labeled "MIKE" and I want to put information from many different
tabs/sheets in column "I" on the main page. Right now I've got the formula
='001'!$l$46...and when I drag it down I want it to pick up sheet '002'!$l$46
for the next line, '003'!$l$46 for the line after...etc. Is there anyway I
can do that?? If someone could help me out I'd greatly appreciate.

Excel Help!!
 

Pl dismiss earlier suggestion. It works, but only up to "009".
See better responses from Peo in .worksheet.functions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---