A
Adyna
I need to find out if there is a way to do this:
Sheet 1:
COL A COL B
item 1 price 1
item 2 price 2
item 3 price 3
Sheet 2: (recipie)
COL A COL B
any item brought from Sheet 1 price of corresponding item
HOW DO I GET the price stored on COL B (sheet 1) to show on COL B (Sheet 2)
once the item (COL A) is selected?
Any ideas?
Thanks a million,
Sheet 1:
COL A COL B
item 1 price 1
item 2 price 2
item 3 price 3
Sheet 2: (recipie)
COL A COL B
any item brought from Sheet 1 price of corresponding item
HOW DO I GET the price stored on COL B (sheet 1) to show on COL B (Sheet 2)
once the item (COL A) is selected?
Any ideas?
Thanks a million,