Merge pdf files based on the common id present in the name of pdf

[Macromurry]

Hello everyone,
I need a macro code that can help me to combine pdf files based on the first 11 digits of each pdf for example in the current screenshot you can see the folder contains approx 900pdfs even though the names are different but there is a common id for each employee I.e. 1000133-001, 1000212-003 and so on I want the files which have the same common id should be merged in 1 pdf naming it as the common id for example all pdfs having common id as 1000133-001 should merged and named as 1000133-001_Q4 2022 CAS.

We have office 2016

Can somebody help me with it ??

 

[Macromurry]

No replies

 

[duggie33]

I am not sure anyone understands what you are trying to do in Excel. I read it three times and I am not sure...is there a screenshot somewhere?

Do you want Excel to merge multiple pdf files into a single pdf file? I do not know if that is possible.

Doug