sheet index in a formula

M

Mr T

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!
 
M

Marcelo

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and match formula resulting in #REF 5
Referencing formula using Indirect 4
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Pulling From Multiple Sheet 0
Help with Index formula 2
Formula Help (IF) ... INDEX 1
IF INDEX and MATCH function together 7

Top