View Single Post
 
Old 03-07-2016, 12:25 PM
Auto Auto is offline Windows 8 Office 2007
Novice
 
Join Date: Mar 2016
Posts: 9
Auto is on a distinguished road
Default Find a match and move row to top of page

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
File Type: xlsx sample.xlsx (19.9 KB, 10 views)

Last edited by Auto; 03-08-2016 at 01:06 AM.
Reply With Quote