Macro that will print/save as PDF with file name a cell, replace cell and repeat

Hello,

Please see attached example.

I have a cell E8 that is a employee number. I would like a macro that printed (or saved) as a pdf the "Overview" page. The printed (or saved) file needs to be the employee number in E8.

After printing (or saved) to replace cell E8 with the next number on the "Numbers" Sheet and repeat the process.

Here are the first 5 examples:

AAC00047586
AAC00027455
AAC00026590
AAC00056862
AAC00045062

I would want the number in E8 replaced by each of these and the file names to match the information inside like this...

AAC00047586.pdf
AAC00027455.pdf
AAC00026590.pdf
AAC00056862.pdf
AAC00045062.pdf

Thanks in advance!

.
This is one way. Paste macro into a Routine Module.

Please Login or Register  to view this content.

Requires a folder on your desktop (edit the path in the macro to match your desktop) named : EMPLOYEES

Originally Posted by Logit

.
This is one way. Paste macro into a Routine Module.

Please Login or Register  to view this content.

Requires a folder on your desktop (edit the path in the macro to match your desktop) named : EMPLOYEES

This worked perfectly! Thanks!

.
You are welcome.