Thread: Transpose Maybe?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan Oakes Dan Oakes is offline
external usenet poster
  
Posts: 16
Default Transpose Maybe?
Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan

Reply With QuoteReply With Quote