Transpose Indirect formula

A

albertnhc

=TRANSPOSE(April01!A1:C1)

Got above formula in a sheet and would like to link it to several sheets by using indirect formula - i.e have April01 in say cell F5 (I'll input April02, April03,...in cell F5)
Am looking for something like this: =TRANSPOSE((INDIRECT(F5)!A1:C1)) - but it's not working - Could someone give me the correct formula - thxs beforehand.
a
 
C

Claus Busch

Hi Albert!

Am Mon, 8 Apr 2013 19:00:49 -0700 (PDT) schrieb (e-mail address removed):
=TRANSPOSE(April01!A1:C1)

Got above formula in a sheet and would like to link it to several sheets by using indirect formula - i.e have April01 in say cell F5 (I'll input April02, April03,...in cell F5)
Am looking for something like this: =TRANSPOSE((INDIRECT(F5)!A1:C1)) - but it's not working
Click to expand...

try:
=TRANSPOSE(INDIRECT(F5&"!A1:C1"))


Regards
Claus Busch
 
A

albertnhc

=TRANSPOSE(April01!A1:C1)



Got above formula in a sheet and would like to link it to several sheets by using indirect formula - i.e have April01 in say cell F5 (I'll input April02, April03,...in cell F5)

Am looking for something like this: =TRANSPOSE((INDIRECT(F5)!A1:C1)) - but it's not working - Could someone give me the correct formula - thxs beforehand.

a
Click to expand...

thxs
 

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

Using 'indirect' function with full network path 0
Cumulative formula for word table 0
I Need get work this formula 6
Keep original cell formatting when using transpose array formula 1
Indirect/match formula - array 1
Indirect/match formula - array 1
Fuction to return and evaluate fuction 1
Can be here some changes for a faster speed ? 3

Top