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

Cell references in an Excel array formula 4
I Need get work this formula 6
COUNTIF + ADDRESS Issue 1
Create Correct Formula 10
Can be here some changes for a faster speed ? 3
Sumproduct when data column changes 1
Cell/Worksheet references 2
Building closed workbook file path within an Index Function 6

Top