View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jc9972003@yahoo.com is offline
external usenet poster
 
Posts: 38
Default drag formula down from columns that go acros

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