Macro to pull all rows of data that match criteria into its own table in a new sheet

[balston2]

Hello,

I have a woorksheet with many rows of data, where certain rows all have the same order number. I would like to list all rows with the same order numbers consecutively into a new sheet.

My first thought is to use VLookUp however I will not know exactly how many rows will match each criteria and would like a macro that would just find all the rows matching my criteria and group them together in the new sheet.

Thanks for any help!

[Alf]

This is your 7th posting and not one of the previous 6 postings is marked as "Solved" even if you got a solution from a forum member. This is contrary to forum rules and I don't help those who do not follow forum rules.

It's a nice touch to end a plea for help with "Thanks for any help" but if somebody answers you should respond as well!

Alf

[balston2]

I was not sure how to mark a thread as solved. Obvisouly I would be happy to do so, now that I have figured that out. Whenever I receive a solution I always respond and say thank you and let them know it worked. I also always add to the user's reputation.

[Alf]

Whenever I receive a solution I always respond and say thank you and let them know it worked. I also always add to the user's reputation.

That is a very good practise but for your own sake I would suggest you contact a “Forum Moderator” and ask him/her to mark your relevant postings “Solved” or somebody else may do as I did and get the wrong impression.

I always respond

http://www.excelforum.com/excel-prog...ame-sheet.html

http://www.excelforum.com/excel-form...g-vlookup.html

But enough of this let's concentrate on your problem instead. Without knowing much of your problem I would suggest using auto filter but you better upload a small sample file showing your data and how you wish the result to be.

Alf

[balston2]

No thanks. This thread has become very confrontational I'd rather figure it out myself. Good day