Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet index in a formula
I have set up a template with 6 different worksheets. I recieve this template
back from variuos sourses with their input, but they have changed the sheet names. What i propose to do is create a seperate sheet that i can insert into the recieved workbooks and i want a formula to pick out eg. sheet 1 (which could have different names) cell G4. I have managed to index sheets in vba but need help to do it in an excel formula, then for sheet 2, 3 , 4, 5 than 6. I hope this makes sense! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet index in a formula
take a look at embed funcions Indirect and Address, it could help you,
=indirect(address(row number,column number,1,1,sheet name)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Mr T" escreveu: I have set up a template with 6 different worksheets. I recieve this template back from variuos sourses with their input, but they have changed the sheet names. What i propose to do is create a seperate sheet that i can insert into the recieved workbooks and i want a formula to pick out eg. sheet 1 (which could have different names) cell G4. I have managed to index sheets in vba but need help to do it in an excel formula, then for sheet 2, 3 , 4, 5 than 6. I hope this makes sense! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function refering sheet index. | Excel Worksheet Functions | |||
Index Max Off other sheet | Excel Worksheet Functions | |||
How to force workbook to always open on the index sheet tab | Excel Worksheet Functions | |||
I have an index sheet of over 200 worksheet tabs... | Excel Discussion (Misc queries) | |||
Index/Contents Sheet | Excel Discussion (Misc queries) |