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