| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Connect multiple columns in 1 row to another?
I have a worksheet with multiple columns of info in one row.
I want to know if I can link all those columns into another worksheet in 1 row 1 column? EG:A72 - Quantity, B72 - Description, C72 - Cost (Sheet 1) A72 - 1550 ft, B72 - Place & Finish, C72 - $2000.00 Can I move those columns into Sheet 2 - A18 which is my invoice? |
|
#2
|
|||
|
|||
|
Put this formula in Sheet2 cell A18 and copy ober to B18 and C18
=Sheet1!A72 Whatever value is in Sheet1A72 will automatically show up in Sheet2A18, etc etc Vaya con Dios, Chuck, CABGx3 "tb" wrote in message ... I have a worksheet with multiple columns of info in one row. I want to know if I can link all those columns into another worksheet in 1 row 1 column? EG:A72 - Quantity, B72 - Description, C72 - Cost (Sheet 1) A72 - 1550 ft, B72 - Place & Finish, C72 - $2000.00 Can I move those columns into Sheet 2 - A18 which is my invoice? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
Linear Mode
