• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Trying to autofilter 8-10 rows of numbers to sort in a group

Well, you surely helped take all my frustrations away my friend On the first sheet I entered all my criteria and dragged the program How would I add more rows to search for additional criteria say from 10 to 20 If I insert additional rows (go to far left and right click "insert") it will also insert more rows all the way across which splits the location area. I will attach a couple pics after another cup of coffee. Lol.
 
Jack,

Just want to clarify:

1. Source is the Sheet with you original data, (note you must clear the filter to see all rows after running the Macro)
2. Critsht is where you place the search values, you can enter as many rows as you wish
3. Target is where the results of the Search are placed.

cheers

kanti
 
Just curious, is it possible to add a function to "only" find rows 1-8 and not say 1-4 or 1-7. This way If I am looking for an exact I do not have to look over a lot of mess so to speak?
 
Back
Top