Automatically fill info from another spreadsheet?
I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). 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)?
|