Rename files based on Cell Content

Bakerman2, thank you, but it's hanging up on

Please Login or Register  to view this content.

Alansidman, I wasn't able to get this to work...I'd like to avoid the input box and just have it flow automatically.

Thank you Alansidman and Bakerman2. As I looked through both of your replies, I thought of this:

Please Login or Register  to view this content.

It doesn't actually rename the workbooks, but it does create new ones that are named after the branches. If there's a way to make this rename the workbooks created in the first macro, I'm still interested.

Thanks again,

JPDutch

My apologies for taking so long to respond. I actually have 217 branches, which number ebbs and flows as we close one branch and open several others over the course of a year; hence the names keep changing. I'm hoping to find a simple way to manage all of the names.

I keep the branch list up-to-date through the year, and at the end of the year the macros are set to select the branch name, address, and so forth, but then I'd like to be able to save the files based on the names. I only use 5 to test the macro for the moment, and once I know everything works, I change 5 to 217. Hope that makes sense.

Thank you,
JPDutch

I don't know if anyone is reading this deep into the thread, but I'm hoping someone can help me with this. As mentioned earlier, I used this code to create and name files, and it was working well. Then I noticed that it skipped files...files based on numbers (if you could look at the original post under the "First" and "Second" macros, you'll see that the first one creates a file which is numbered 1-5...well now it's up to 218...but the problem is that it skipped files 21 through 99, and I can't figure out why. (Oh, you'll note that I changed the years from 2016 to 2017.)

Please Login or Register  to view this content.

Your advice would be greatly appreciated.

Thank you,

JPDutch

Bakerman2, Thank you; the only problem is that I'm not good at VBA. I've tried to figure this out, but to no avail. Could you give me an example? and would I place the code in that part of the second macro where I have the red wording? I do have the list of branches established in one of the worksheets, but I'm not sure how to reference the list or create the loop in VBA. Any help you could offer would be very much appreciated!

Thank you again,

JP

I've not been completely successful with the code I submitted earlier in this thread. I'm trying to develop one macro (as suggested by Bakerman2) that will create a workbook (an OSHA Log), fill in the data, save the workbook based on the branch's name (there are over 200 branches), close the workbook, and go to the next OSHA Log. The code I managed to develop (still a two-step process) skips a number of workbooks, thus requiring me to finish the remaining 40 OSHA Logs manually. Any ideas will be appreciated.

Thank you for considering this post,

JPDutch