Extracting Data to a different sheet

[usama5788]

Hi,

I had a quick question regarding my attached worksheet. As you can see I have 2 line items. I am looking for some sort of VBA code to extract the whole line item into a different worksheet. So for example in the attachment I would like some sort of VBA code that looks into my data and column C "Doc" and if it has information there that starts with "INV" then I want that whole line item extracted to a new worksheet. So this way after the result I will have 2 worksheets. Hopefully I explained that well enough for assistance.