Hello and thanks in advance for your help!
I have 97 or so worksheets in a workbook. Each worksheet represents a Data Table and has all of the column names from those data tables listed in Column A. I also have a worksheet, named "Unique Fields" that lists all of the unique column names from each of the 97 worksheets listed in Column A.
What I am hoping for is a Macro/Function that will look up each value in my "Unique Fields" sheet, look through all of the other worksheets and then list all of the sheet names that it finds that value in.
For Example:
In my "Unique Fields" sheet, my unique values start in A2 and go to A500. The value in A2 is "ProductPlanID". That value is found in multiple worksheets, such as "ContractType", "FlexProduct" and "Product Status". On my "Unique Fields" sheet, I would like it to return B2 as "Contract Type", C2 as "FlexProduct", D2 as "Product Status", etc.
Any help would be greatly appreciated!
I have 97 or so worksheets in a workbook. Each worksheet represents a Data Table and has all of the column names from those data tables listed in Column A. I also have a worksheet, named "Unique Fields" that lists all of the unique column names from each of the 97 worksheets listed in Column A.
What I am hoping for is a Macro/Function that will look up each value in my "Unique Fields" sheet, look through all of the other worksheets and then list all of the sheet names that it finds that value in.
For Example:
In my "Unique Fields" sheet, my unique values start in A2 and go to A500. The value in A2 is "ProductPlanID". That value is found in multiple worksheets, such as "ContractType", "FlexProduct" and "Product Status". On my "Unique Fields" sheet, I would like it to return B2 as "Contract Type", C2 as "FlexProduct", D2 as "Product Status", etc.
Any help would be greatly appreciated!