Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|