Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Data to Appear as Column Headings in Another Sheet
Hi
I have data listed in Column A in Sheet 1 (Rows 1 to 100) that I would like to appear as Column Headings in Sheet 2 (Columns A to Column CV). Is there a formula or drag method that I can place in Sheet 2 that will flow this information through easily? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Data to Appear as Column Headings in Another Sheet
=INDIRECT("Sheet1!A"&COLUMN()) and copy across
-- Gary''s Student - gsnu200816 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add column headings to the single sheet. | Excel Discussion (Misc queries) | |||
Sheet Column Headings and Row Labels | Excel Worksheet Functions | |||
How do I create column headings at top of every sheet? | Excel Worksheet Functions | |||
Inserting data that has different column headings | Excel Discussion (Misc queries) | |||
different sets of column headings - same sheet | Excel Discussion (Misc queries) |