I have created a spreadsheet with 3 worksheets. The master worksheet (sheet 3) has multiple tables that contain different materials and a quantity. Each table has a distinct name that correlates to a standard and each standard has it's own set of materials and quantities.
One the first sheet, which is the sheet the user will interact with, each line item represents a work point. The user will enter data, including one column where they select the standard (from a pick list) that correlates to a table name from sheet 3.
On the second sheet I need the materials and qty to populate in a list format for each work point based on what was selected on sheet 1 for that work point/line item, derived from the correlating standard table on sheet 3.
My examples are from an old version of Excel that I am working on from home, but I do use 365 at work and this will be done using 365.
'
I would appreciate any help I can get. I thought I could do this easily but cannot figure it out..
One the first sheet, which is the sheet the user will interact with, each line item represents a work point. The user will enter data, including one column where they select the standard (from a pick list) that correlates to a table name from sheet 3.
On the second sheet I need the materials and qty to populate in a list format for each work point based on what was selected on sheet 1 for that work point/line item, derived from the correlating standard table on sheet 3.
My examples are from an old version of Excel that I am working on from home, but I do use 365 at work and this will be done using 365.
'
I would appreciate any help I can get. I thought I could do this easily but cannot figure it out..