Hello! :-) Thank you in advance for reading!

I'm feeling useless, as I had to use macros as part of a course in college, but now I actually need one - my mind is blank!

I'm using excel 2011 for mac, and I need a way to copy rows of data into an additional sheet, if a condition is met. For example if a certain cell contains a particular word/phrase.

I'm sorting through a database of thousands of stock order entries, and I really need a quick way to separate out orders for certain things, for use at a later date. (...with a mail merge, but that's another task)

Its very simplistic - just a data dump from our online store. Presently its a single sheet with columns a-k having the customers order number and ship details in, column L is the one with the order contents in.

If there was say, 'chair' in sheet1column L, I'd like the order record (whole row) copied to sheet 2.

Could someone help a girl out? :-) I'd really appreciate it, as I'd rather not have to sift it by hand...