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