I am trying to create a 'dashboard' where the user selects from a drop down box the product type (all of the product types correspond to a different worksheet, in the same workbook).
I would then like the other fields on the dashboard to be calculated based on the information on the corresponding product type worksheet?
Is this possible?
I would then like the other fields on the dashboard to be calculated based on the information on the corresponding product type worksheet?
Is this possible?