I have a table with 4 columns and what I was trying to do is:



1. Make a user input box
2. Search in Column "A" for user input
3. If item is found several rows down bring that row to top of page.

The idea here is to bring up data values that might be several hundred rows down and bring that data to the top of the page. I'm sure there must be a way to do this but I don't have a clue how to make it work.

I attached a sample file to use if need be.


Thanks in advance everyone.

Attached Files

sample.xlsx (19.9 KB, 12 views)