A select query in excel?

I have a decent amount of data and each row of data has attributes attributed to a person. The same person can be in the table more than once. What I'd like to do is create some sort of pop up table/form (after they hit a certain button specific to them) in excel for each person showing them all the rows of attributes. It's kind of like running a select query in excel on excel data.

The person would then be faced with 2 choices approve or disapprove in button form perhaps on the popped up form/table. After clicking one of the buttons, it puts their initials in either a disapprove or approve column. Also, if they hit disapprove, I'd like a pop up message to appear.

Is this possible in excel?

What may suit your needs is on a button click, pop a form that asks for the person's name, then filter the sheet with the attributes for that person.
They can then click the approve/disapprove button.
I don't know how many rows/attributes there are, so they may not fit in a form; or the person may need to scroll up/down or left/right to see all of their attributes.

An alternative is to show the attributes on a second sheet.
But yes this would be doable in Excel

I think what I'll do is the advanced filter to bring the data over. My question is, can I have the person type there name in the Criteria Range and have the filter automatically run to bring over the data? That way they don't have to do anything. How do I do that?

When you say "... the advanced filter to bring the data over." Are you filtering or copying data? If filtering, there is nothing to bring over, you're on the attribute spreadsheet.
You can have the person click on a button to kick off the filtering. As far as I know there is no event trigger when you enter data into a cell, except in a form.

hectop - Thank you for the guidance.

So after your last comment, what I think I'll do is have 2 worksheets. On sheet 1, they enter their name into a certain cell, which will be my "Criteria Range" for the advanced filter. They will then hit a button to run the advanced filter, which will bring over the data from the second worksheet.

I'm not too familiar with VB; is there anything I should know (helpful tips) before I try to figure this out?

Thanks again!

There was a similar question a little while ago that I answered. The attached worksheet will show how it can be done.
One thing to notice here is that there is a Create Emp ID List button. This would (re-)create a named range of employees so that you could you a drop down list to select the name rather than have the name typed in. This would ensure that there are no typos or inconsistencies in how the criteria range is populated.

Have fun with it.
PopEmpDtls.xlsm

Brilliant! Thanks!!!

The button Create Emp ID List executes the subroutine DedupEEs which creates a list of unique employee ID numbers in column J
You need to modify it:
- Worksheets("Raw").Cells(nRRow, 1).Value. Change the 1 to the column that has your names (that you use for criteria range selection)
- nRngCol = column that you want your unique list written to
- sRng = "=Raw!R2C10:R" & Trim(Str(nSRow)) & "C10"
- you need to change R2C10 to the relative row/column where the unique list starts
- the last C10 is changed to the relative column number where the unique list is located. This needs to be the same as 1st C10 in this line

Hectop - Thank you so much! I was able to adjust the code with your instructions and can now use my spreadsheet with no errors! I appreciate your Excel/VB expertise as it has saved me hours of headache and I also learned a few things along the way. THANK YOU!!!

Alan - Sorry about the code rule. It won't happen again.

Your welcome. Please click on the Add Reputation button.
Thanks

Yep - I added to your rep yesterday. I guess this thread is solved.