I have a workbook with many spreadsheets for assemblies.
In the assembly spreadsheets I have detail part numbers that make up the assemblies. I pull prices for each detail from another reference spreadsheet. If there is no detail listed in that spreadsheet, the price field yields an error.
What I want to do is make another sheet in the main workbook (not reference) that looks for the errors and returns the detail part number that have no prices in a list that I can then round up prices for.
Is this possible?
In the assembly spreadsheets I have detail part numbers that make up the assemblies. I pull prices for each detail from another reference spreadsheet. If there is no detail listed in that spreadsheet, the price field yields an error.
What I want to do is make another sheet in the main workbook (not reference) that looks for the errors and returns the detail part number that have no prices in a list that I can then round up prices for.
Is this possible?
