EXCEL VBA: Create Unique Folders based on Repeated Cell Values

Hello,

I have a workbook with two sheets. One sheet contains a form, and the other contains rows of data. The script below populates the form ("Form_1") using the data in the other sheet ("Sheet3"). Once a row of data has passed through the form, a PDF of the filled form is created. Currently, I'm able to create a folder where all the PDFs go to after the script is done passing through all the rows.

I, however, would now like to create subfolders (Logistics, Engineering, Research and Development, etc.) within the main folder (Output) and store the PDFs created within its pertaining group. I don't know how to go about this with the script I have since I have entries with the same group.

May I ask for someone to help me out with this?

Thanks in advance!

Please Login or Register  to view this content.

pic.JPG

Thanks in advance!

Note: Forgive my lack of expertise in posting a good question if it isn't. I'm new to this forum. I'll sooner than later get the hang of using the question tool. I see that there is an attachments icon. I'm not sure if I could've provided a sample of what I'm working with through there. I wasn't able to make it work. Hopefully the pictures I provided are enough context to help me out.

Hello ChunkyFresh,

Welcome to the forum!

Give this a try...

Please Login or Register  to view this content.

Hello ChunkyFresh,

You're welcome. Good to know it made your job easier. I'll take care of marking the thread solved.