Thread: Column Data to Appear as Column Headings in Another Sheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Monk[_2_] Monk[_2_] is offline
external usenet poster
  
Posts: 65
Default Column Data to Appear as Column Headings in Another Sheet
Thanks. One final question. How would the formula appear if the data in
sheet 1 commenced in row 3 and the column headings in Sheet 2 commenced in
Column C?

"Gary''s Student" wrote:

=INDIRECT("Sheet1!A"&COLUMN()) and copy across
--
Gary''s Student - gsnu200816
Reply With QuoteReply With Quote