ellsworth2000
asked on
need excel column to reference a secondary worksheet to corresponding entries with adjacent info
Greetings Experts!
im putting together an excel document used for inventory tracking. I have one worksheet called "On Going Inventory" that has only the data for Column A and needs the corresponding data for Column B and C. The corresponding data all resides on worksheet "Master Inventory". Is it possible to make column B and C on the "On Going Inventory" worksheet automatically populate once inputted to Column A? I attached my sample worksheet.
Many Thanks - Ells
im putting together an excel document used for inventory tracking. I have one worksheet called "On Going Inventory" that has only the data for Column A and needs the corresponding data for Column B and C. The corresponding data all resides on worksheet "Master Inventory". Is it possible to make column B and C on the "On Going Inventory" worksheet automatically populate once inputted to Column A? I attached my sample worksheet.
Many Thanks - Ells
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!
ASKER
Sample-Inventory-Sheet.xlsx