Connect multiple columns in 1 row to another?

G

Guest

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?
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing address block: sorting 1 row to columns 1
Copying Formulas from One Worksheet to Another -- Very Easy Questi 3
Extracting data from Multiple columns to a Single row 1
Resize a row but copy but skip columns I don't want to copy 6
Copy data from unlocked cells 3
how do i reference multiple rows/columns with one function? 1
Multiple columns into single row 3
How can I have a row copy to another worksheet based on dropdown v 1

Top