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! |
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! |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com