Macro to extract Data

**dandavis1** · 10-07-2008, 07:09 AM

I would like to create a macro so that it will pull all the data from the worksheet "Data" and put it onto worksheet "Extracted Data". However I only require the rows which have Booking Office No SU17.

Can this be done?!?

Thanks very much!!!!

**StephenR** · 10-07-2008, 07:17 AM

You don't need a macro, but here is one:

Please Login or Register  to view this content.

**dandavis1** · 10-07-2008, 07:25 AM

This is great, however I need the data to also stay in the "data" worksheet as well as it being extracted seperatly into the "extracted data" worksheet.

Many thanks!!!