Please help me find a method to make storage data entry populate from one sheet to another.
Sheet 1 called “product details” has in column A names of products and next to each cell the price in column B.
Other sheets each has table where i can enter list of products and quantities. I want the cell next to each product fill the price automatically so I can make the next cell the cost based on quantity I enter BUT read the price from sheet 1 as a linked data so it change on all sheets when making the change on sheet 1 “product details”.
What I’m currently doing is naming the filed of each cell in Sheet 1 for both name and value
Example:
A1 is “Prod01” in the cell reference name field, where the cell contain the long actual name of the product.
B1 is “Prod01_P” the price.
Now on the other sheets I use “=Prod01” where ever I want to enter the product name, then next cell “=Prod01_P”.
This is confusing because the document now contain over 30 sheets and is growing to about 70 sheets… I want something easier.
I tried making a rang list on the sheet1 then use validity on the other sheets to choose from list but this is still too much confusing and cells don’t end up changing when I change anything from Sheet 1.
Thank you for taking the time to help me out.