save filtered data as separate file with different name

[MikeTE]

hello,

I have problem with saving filtered data as separate file. I recorded macro and that works however it is saving everything as "book1" when I changed it to range the code tripped. the aim of this file is to compare extracts from fin programme to find new transactions, highlight them, filter and save filtered entries as separate file with today's date format eg. 10 February 2020
can anybody please help me to fix it?

ps I don't know how to add the code here correctly so I attach the test file. data is taken off for safety.

thank you
mike

 

[Hui]

I don't have time to specifically answer your post but maybe have a look at these two posts

Advanced Filter:
Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[MikeTE]

thank you for response. I have already used the mentioned example for other things but it would not work in this case.

 

[Marc L]

Hi,​

​

create first a new workbook then use filters - or better an advanced filter - to copy the data to the new workbook,​

it always works like this since last century !​

​