View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan Oakes Dan Oakes is offline
external usenet poster
 
Posts: 16
Default Transpose Maybe?

This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan