Connect multiple columns in 1 row to another?

[tb]

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?

[CLR]

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" <tb@discussions.microsoft.com> wrote in message
news:7B46C5CC-7627-43D8-A5BA-0A2E83E5F962@microsoft.com...
> 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?
>