Extract rows of data based on keyword

Below I have tried to explain the steps of a macro as clearly as possible to help you understand what is happening so that you can modify it as required.
I have also re-atached your spreadsheet with the macro loaded into it.

Please Login or Register  to view this content.

Thanks chaps,
I'm working through your solutions. I'm getting somewhere with Phil's solution.
But i figure i may as well show you a more detailed example. My actual workbook will be similar to that attached. Unfortunately i can't put all the data in that i will need it to use - confidentiality and all that jazz.
I will need whatever solution i use to extract the data depending on the quoter and deposit in the corresponding sheet. If you can put a working example in here that i can bastardise and copy into the actual sheet, that would be absolutely chuffing amazing!!!

Helps if i attach of course....bloody newbie forum users eh???

Doesn't seem to work chief on my machine I'm afraid....i only get one entry for Andy H, duplicated across all the sheets!! FYI the second table is not relevent to this exercise, that will get filled in by different means.

Ah yes, that does the trick...the only thing now is that i have the first line (the Andy H entry) as the top line on each of the sheets, almost like a column heading. I can live with it, but would rather it wasn't there!!
This is top drawer by the way!!!

Spot on my man!!
I shall now attempt to reverse engineer it and work out what the hell is going on!!
Many thanks for your and all others' help!!
Ali Mac (TheRetroChief)

Is there any way to automate it so that you don't have to run the macro each time you put a new row of data into the first sheet??? It will be added to on a regular basis and used by multiple users who will undoubtedly forget to run the macro!!

Many thanks,
Ali Mac

Hello- New post, I am a young winger trying to replicate this method for a bank balance statement copy and pasted into an excel spreadsheet.

Only difference is that I am trying to isolate all the rows pertaining to ASDA purchases all contained in the C column of the sheet.

I tried to copy the 2 codes above exchanging the entry for "Andy H" for keyword "Asda", and changed A1 "quote" to C1 "description"

Am I just a complete novice or am I going along the right lines?? I am trying to figure out my student expenditure.

John Paul, UK

John Paul,
Welcome to the forum!
Unfortunately, this does not copy with forum's rule.
You need to start your own thread. Please read forum's rules.