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?

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?