Hi,
It looks as if you want to use the Data in B1 to Name a file and then loop back for the next file and name it. But you want to use a input box for the next name.
In stead of that can you not put the 1st change in B1 then in B2 the next change and loop down column B?
|