Macro to copy rows of data based on a value supplied

I have attached a simple workbook which I would like to copy rows of data that matches my search criteria to another workbook. For example, in column A, I would like to copy all the rows of data to a new workbook any row with "SK". Or I may want to copy rows of data that MB is chosen in column A. This could be simply by entering SK in a certain cell or a userform. Thanks for the base as the actual spreadsheet has many more rows and columns, but all I need is the basics and I can build from there!

Base code to start with

Please Login or Register  to view this content.

Wow jindon! Thanks for such a quick reply!! It works 100% as I asked, but I forgot to include the ability to omit a column, say for example column D?

The add one line

Please Login or Register  to view this content.

Awesome jindon! Is there a way to add that to the inputbox so it is variable, meaning one time it might be column "D", the next it might be column "E"?

What's more do you want to ask?

I posted the basic code due to the vague question.

Originally Posted by jindon

What's more do you want to ask?

I posted the basic code due to the vague question.

Yes, I know, I do this everytime, I always don't think it through enough when I ask the initial question, then as answers come, I think of another thing. I am sorry about that and promise, that is the last change.

Yes, I understand and hear you jindon and again am sorry for this. Thanks for ALL of your help and this is a good base for me to work from. MUCH appreciated!!

You are welcome and thanks for the rep.

As you can see above, I really appreciate the effort jindon has done and provided me with an excellent base to build from. His last proposal works great, but not exactly what I am after.

1) The ability to filter one column, for example A.
2) The ability to not include one or more columns, for example D, but could be any combo of 1 or more columns.
3) Create a new workbook as the result of 1 & 2 above.

I see that I worded it wrong above, thus why the further request.

1) Think deeply how it should be handled.
2) Build your own UserForm with controls that enables you to enter information for above, if you need one. (no code)
3) If you don't need UserForm, propose other means of entering information.

You should do above before you ask.