macro to copy data and paste to new worksheet

[Christy416]

I have been experimenting in excel trying to find a way to copy data from one worksheet, based on each change in criteria in column a, and paste it into multiple worksheets based on that criteria. I have managed to create a macro to cover the rest of my needs but I am stuck on this one piece. Any help would be greatly appreciated!

[VBA Noob]

Link may help

http://www.rondebruin.nl/copy5.htm

VBA Noob

[Christy416]

Oh goodness. I reviewed the link that you sent to me and I am not that advanced in excel.

[VBA Noob]

Post an example and I'll take a look

VBA Noob

[Christy416]

Thank you! Something that I thought would be simple has turned out to be very complex. I simplified the data and put it in a document. Hope this works. I appreciate your assistance.

[VBA Noob]

So just to confirm you want a new sheet for all the criteria and copy over the lines

E.g House would have 11 lines

Unknown
House
Northern
Southern
Western

VBA Noob

[VBA Noob]

Try

VBA Noob

[Christy416]

Oh My Gosh! That' so wonderful! That will work perfectly for my project! Thank you again!

[VBA Noob]

Your welcome

VBA Noob