Macro to filter by two columns and save file

[kay007]

Dear Jindon,

There is a solution you provided in the link below that i would love to adapt and adopt for my own use.

http://www.excelforum.com/excel-prog...save-file.html

My twist:

I have a database that should be splitted into new workbooks by using the "Report Name one and two" as the basis of separating the data. The twists are:

TestData.xlsx

1. If a name appears in both under "Report name one and two" then the data should be extracted together else the "Report name one" should suffice. e.g. WS appears both in the Report name one and two, i would prefer the are extracted together into just one workbook.
2. I only want to extract selected headers from the "Data" Sheet rather than everything. See the "Desired Output" sheet for the headers of interest.

I dont know if i am asking for too much..However, any help will be much appreciated.

[jindon]

Your explanation and the result are not clear to me.

Do you want to create only one workbook based on "Data" sheet?

If not, I need to see more result for each new workbook.
If true, why those 3 rows?

[kay007]

Here are some of the some the data extracted to new workbooks.

WS.xlsx
MT.xlsx

[kay007]

The deal is to extract data based on column E and saved as a new workbook.. However, there are some Items in Column F that should be extracted along with the data in column E.

[jindon]

See if this is how you wanted.

Please Login or Register  to view this content.

[kay007]

Fantastic Jidon! it worked beautifully well (Really need to come and learn).. Just wondering if i can play around with the headers..

For example: if i decided to use another set of headers that are different from the initial one included in my earlier sample workbooks, will this code still handle? or can you help tweak this code so that the headers can be read from a range somewhere in the workbook. This would give me the flexibility to add or remove headers or any of the columns without wading through the code to modify.

I have included another sheet showing the report headers in the "Mapping" Sheet.

TestData_1.xlsx

Many thanks again for your time!

[jindon]

Please Login or Register  to view this content.

[kay007]

yiiippppiiiee! It worked as designed... To think i have been thinking about how to go about this for days..

I am truly grateful Jindon! Many thanks once again for taking time to help out with this!

Regards!