Here is a reference file:

EXCEL MACRO PROMPTS.xlsx

I’m looking to create two prompts. One will ask the user to “Enter Name here as shown in sheet 1” and he/she will enter for example “Part 8” (it could even work to put the cell designation if that would be better?). This Name (which can be found in row 2) corresponds to a column of data. Based on the input text, I want to find all non-blank/non-zero cells in the column indicated. From those non-blank/non-zero cells, the macro will take the corresponding cells from column B of the worksheet and copy them to column B of ‘sheet 3’.


The second prompt will ask “Please enter the Test as shown in sheet 2” and the user will type something like “Test 5” (it could even work to put the cell designation if that would be better?). The goal is similar. It will look to row 1 for the text corresponding to the correct cell (i.e. Test 5). The column pertaining to this cell will be searched for all non-blank cells. The cells in column D, E, and F which correspond to the rows of the non-blank cells will be copied into ‘sheet 4’ columns A, B, and C.

Thank you for your help!!