| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linked data
I have the following information on one worksheet that I need to transfer to
a new worksheet in another format. Refer Acct Amt 80312 43700 -36,500.00 80312 43705 39,518.76 80312 12300 -44,704.76 80312 11606 5,186.00 I need it to look like: (D3)Refer (A4)Acct. (D4)Amt. with the acct. #'s going down column A, starting at row 4, Refer #'s across Row 3, starting in column D and the amt automatically filled in at D4. I have a lot of data to enter this way and I'm hoping someone can tell me how to populate the second sheet without having to enter everything again. I tried SUMPRODUCT, but it didn't work. thanks ahead of time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| How to transpose linked data and keep it linked? | Excel Worksheet Functions | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Linear Mode
