Sharing Info between two workbooks?
I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). In (A) I have listed product name along with product number. Is
it possible to enter the name of product in spreadsheet (B)
and have the next cell automatically fill in product number from spreadsheet
(A)?
|