Filter, print as pdf, save to folder according to cell values

[Lux Aeterna]

Hello everyone!

I have got an excel file that looks something like this

id	pending	name	place
1	Yes	John	Athens
2	No	Jill	London
3	No	Jake	Berlin
4	Yes	Jacob	Manhattan

What I'd like is a macro that filters places and create separate PDFs for each place. Then I need each PDF to be saved to a different folder according to two cell values.

The list of places is in column G (starting in G5, ending in G10033). Some cells are blank and one cell is named stop. They can be skipped.

Save folder is "C:\Users\pc50\Desktop\New results\Place_value\D3_value\

Name of the PDF file can be "Place_value - List D3_value", which would be something like "Athens - List 2023".

Print area for the whole sheet, in case needed, is A1 to G10033, but I guess it will be automatically adjusted after the place is filtered, from A1 to Gxxx.

Thank you in advance!

 

[Lux Aeterna]

Forgot to mention

Also check if folder exists and create if not.

Thanks!