How do I link a cell to 2 other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top