Export 240 worksheets as PDF and add the correct name

I have a file that I format and split into 240 separate worksheets, I then have to save each of those into PDF with a very specific format. For example, Tauner, Alisha, 00001018990589, 08.10.16, 03.47.46 PM, 0.39.39, Inbound


Is there a way to export all 240 as PDF and for naming purposes reference a list of names and match a value, in this case, the long number and the name. BUT in the 240 sheets, the long number would say "Packet Ref ID: 00001018990589" and the name would be "Alisha L Tauner" so it couldn't match 100%.

Figure that is likely a bit much, and I have a code to export as pdf, just the naming is off.

Please Login or Register  to view this content.

OK, so this is aimed at the hardest of the two approaches.

Book 1 has four sheets. Sheet 1 is the filenames, that is the exact name it has to be. the next three sheets are what the notepads look like. So then you export each sheet separately as a PDF and name it accordingly.

There will be 240 file names and 240 separate sheets.

Yes, I think you are on the right tract, that is a simple and concise way to put it.

And I would like to be able to have a prompt for the destination of the PDFs, so if someone else needs to do this in the future, they do not have to adjust the code.

Hey man, I think you really surpassed what I even thought possible! but out of 240 file names, only one was found and exported, but it was done perfectly! i've attached a sample with three that were not located. I adjusted the names and numbers to anonymize them. But now when I run the macro, I get an out of range error for

Please Login or Register  to view this content.

Sorry I am so far behind in testing and responding and I hope this finds you.

Hey, disregard!!! It works!! it was my fault. I ran it before splitting the notepads into the 240 different sheets. Dumb early morning mistake on my part!

Now if I can figure out why my macro that splits into 240 sheets has all of a sudden decided to not work as it had.