If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Data Horizontally from Vertical List
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
|
|||
|
|||
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
|
|||
|
|||
Thanks Jason for the quick comeback....works just like need........ |
Thread Tools | |
Display Modes | |
|
|
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 |