Copying Data Horizontally from Vertical List

#1 August 27th, 2004, 12:35 PM

On Sheet1 I have a Column of data, call it ColA.

On Sheet2 I'd like to transfer Sheet1!A1 to Sheet2!
A1...simple enough.

=Sheet1!A1 entered in Sheet2!A1

Now I'd like to copy/drag across Row1/Sheet2 such that
Sheet1!A2 goes into Sheet2!B1, Sheet1!A3 goes into
Sheet2!C1...etc.

I've tried dragging the above and also =Sheet1!$A1,
neither give me the desired results.

Is this impossible or what am I doint wrong?

#2 August 27th, 2004, 12:52 PM

Try:

=OFFSET(Sheet1!$A$1,COLUMN()-1,)

HTH
Jason
Atlanta, GA

-----Original Message-----
On Sheet1 I have a Column of data, call it ColA.

On Sheet2 I'd like to transfer Sheet1!A1 to Sheet2!
A1...simple enough.

=Sheet1!A1 entered in Sheet2!A1

Now I'd like to copy/drag across Row1/Sheet2 such that
Sheet1!A2 goes into Sheet2!B1, Sheet1!A3 goes into
Sheet2!C1...etc.

I've tried dragging the above and also =Sheet1!$A1,
neither give me the desired results.

Is this impossible or what am I doint wrong?
.

#3 August 27th, 2004, 01:42 PM

Thanks Jason for the quick comeback....works just like
need........

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Updating data in a lookup list in a form	P Mitchell	Using Forms	2	July 16th, 2004 03:58 PM
Problem copying outlook data	Qal	General Discussion	4	July 7th, 2004 10:15 AM
MailMerge - merge with data in Excel - arranging data vertically instead of horizontally	paul	Mailmerge	1	June 21st, 2004 03:48 PM
Extract data from table to make a list of cell values	JoeBlow	Worksheet Functions	3	June 10th, 2004 07:42 AM