How do I link a cell to 2 other cells
 

Hi,
Can anyone tell me how to link the data in A7 (item) to B7 (description) and
E7 (price) in worksheet 1, then link all above data to worksheet 2 by
clicking A7?
Please tell me how to do this. I have a price log (worksheet 1) that I am
trying to link to an invoice (worksheet 2).
Thanks

How do I link a cell to 2 other cells
 

You could try something like this

=Sheet1!A7&", "&(Sheet1!B7)&", "&(Sheet1!E7)
place this formula in Sheet2 where you want the results and it will show
" Item, Description, Price "
in one cell. no need to click on a cell, it will update automatically
HTH

"Missy" wrote:

Hi,
Can anyone tell me how to link the data in A7 (item) to B7 (description) and
E7 (price) in worksheet 1, then link all above data to worksheet 2 by
clicking A7?
Please tell me how to do this. I have a price log (worksheet 1) that I am
trying to link to an invoice (worksheet 2).
Thanks