Thanks in advance for any possible help. I can't figure out the vba code to make this work.

Here is a summary of what I am trying to do:

Cells a1 to a 50 have location numbers.

I need to copy cell a1 to cell c1. When that occurs cell d1 displays a name. Then I need to export the file to pdf with the name C:\test\d1\c1.

Then I need to repeat for cells a2 through a50.

The other catch is that sometimes the A column might have more or less than 50.

I can get the the exporting part and copying part correct but I am having problems trying to loop this for all 50 or so and save using the name format.

Again, thanks for any and all help - Folks on this forum have been extremely helpful.
Sid