Help
I'M Linking a cell from anothe spreadsheet that goes across "columns"
and my spreadsheet goes down"rows" I need a formula that will let me just drag down and get the content below
Example
spreadsheet copying from

JAN FEB MAR APR
1 100 200 300


Mine
This would be the would be the answer and I want to drag down
Jan 100
feb 200
mar 300
apr

Hi,

Am Thu, 25 Apr 2013 08:30:02 -0700 (PDT) schrieb :

spreadsheet copying from

JAN FEB MAR APR
1 100 200 300

Mine
This would be the would be the answer and I want to drag down
Jan 100
feb 200
mar 300
apr

you can copy and paste special = Transpose
Or you can write the month in column A and then in B1:
=HLOOKUP(A1,Sheet3!$A$1:$Z$10,2,0) and copy down.
If you want a formula for the month too, then in A1:
=INDEX(Sheet3!$A$1:$Z$10,1,ROW(A1))
and in B1:
=INDEX(Sheet3!$A$1:$Z$10,2,ROW(B1))



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Thursday, April 25, 2013 10:30:02 AM UTC-5, wrote:
Help I'M Linking a cell from anothe spreadsheet that goes across "columns" and my spreadsheet goes down"rows" I need a formula that will let me just drag down and get the content below Example spreadsheet copying from JAN FEB MAR APR 1 100 200 300 Mine This would be the would be the answer and I want to drag down Jan 100 feb 200 mar 300 apr

Thanks

On Thursday, April 25, 2013 10:30:02 AM UTC-5, wrote:
Help I'M Linking a cell from anothe spreadsheet that goes across "columns" and my spreadsheet goes down"rows" I need a formula that will let me just drag down and get the content below Example spreadsheet copying from JAN FEB MAR APR 1 100 200 300 Mine This would be the would be the answer and I want to drag down Jan 100 feb 200 mar 300 apr

Thank you