Quote:
|
When I put the code into the cell, I am prompted to open a new document! Is this correct?
|
This is happening because you don't have a sheet currently in your workbook called "Results". You would need to update the formula to point to the sheet that you entered my first formula in.
Secondly, my solution is based on you starting from scratch. However, if the data in the other sheets is identical to what is in your results sheet, you should be able to clear the data from those sheets, enter my formula in each of the sheets (making them correspond to the correct item) and then the data from the results sheet should re-appear.
I attached a sample from your sample.
I created the Results sheet, where you enter the info.. and the item A sheet shows you the extracted "Item A" only items.
Make a copy of your original workbook for backup before applying these suggestions.