Transpose Indirect formula

  • Thread starter Thread starter albertnhc
  • Start date Start date
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
 
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
 
=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
 
Back
Top