PC Review


Reply
Thread Tools Rate Thread

Column Data to Appear as Column Headings in Another Sheet

 
 
Monk
Guest
Posts: n/a
 
      27th Nov 2008
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.
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      27th Nov 2008
=INDIRECT("Sheet1!A"&COLUMN()) and copy across
--
Gary''s Student - gsnu200816
 
Reply With Quote
 
Monk
Guest
Posts: n/a
 
      27th Nov 2008
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 Quote
 
Monk
Guest
Posts: n/a
 
      27th Nov 2008
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 Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add column headings to the single sheet. Richard Fern Microsoft Excel Misc 0 5th Jul 2008 04:21 AM
How do I create column headings at top of every sheet? Don J Microsoft Excel Worksheet Functions 2 20th Nov 2006 03:17 AM
different sets of column headings - same sheet =?Utf-8?B?ZGViaWRv?= Microsoft Excel Misc 1 31st Aug 2006 09:11 PM
Sheet Column Headings and Row Labels =?Utf-8?B?bW9uaXI=?= Microsoft Excel Worksheet Functions 8 20th Apr 2005 04:11 PM
Column headings in Excel w/sheet Gerry Ward Microsoft Excel Worksheet Functions 1 19th Jun 2004 10:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:39 AM.