Ok where I work we have a certain part hat is named such as (ABCD1234), that part gets multiple tests done. Each test generates an excel worksheet with that part number and a list parameters and subsequent results. These sheets for sake of argument are called (sheet1), (sheet2), (sheet3).
I want to make a master sheet called (Master) that has a list of all the parameters of all tests. Then empty boxes next to all of them. At the top I want a user to put in the part number into a cell, then have a button to click that runs a macro that will find the part number on all of the other sheets and input the data into the master sheet. When the macro looks for the part number in these other sheets, it will have to grab data from them based on the location of the cell that holds the part number if that makes sense. It has to find the location cell of the part number, then grab data in the cell say 2 colums to the right. And then place it where I want it on the master sheet.
I want to make a master sheet called (Master) that has a list of all the parameters of all tests. Then empty boxes next to all of them. At the top I want a user to put in the part number into a cell, then have a button to click that runs a macro that will find the part number on all of the other sheets and input the data into the master sheet. When the macro looks for the part number in these other sheets, it will have to grab data from them based on the location of the cell that holds the part number if that makes sense. It has to find the location cell of the part number, then grab data in the cell say 2 colums to the right. And then place it where I want it on the master sheet.