Create Dated Folder with Subfolder from Cell Values

Hi All-

I'm fairly new to VBA code so forgive me if this is extremely simple and/or poorly worded... To note: I am on Excel 2011 for MAC. What i would like to do is create one button and assign one macro to it. I would like the macro to create a dated folder with today's date (mmddyy) and then save subfolders with the folder names determined from cells A1_B1, A2_B2, A3_B3, etc.

So essentially the final directories would look like this:

Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A1_B1
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A2_B2
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A3_B3

This is the code that I am currently using. It creates folders with the date and folder name like this: 101614A1_B1

Please Login or Register  to view this content.

Any and all help would be greatly appreciated!!!

Maybe this:

Please Login or Register  to view this content.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

Maybe:

Please Login or Register  to view this content.

That macro doesn't have the ability to create more than the one folder at the end.

Notice how we fixed your original macro my explicitly creating the main directory before we entered to "loop"

Please Login or Register  to view this content.

I would think you need to do that again to add the "Wall" folder:

Please Login or Register  to view this content.

The rest of the original macro can remain the same, making the inside folders inside the WALL folder.

Thank you!! That got me set on the right track. I tweaked it a little and it now does what I need it to. Thank you! Here is what I have as final macro and it works for me. I'm sure its not beautiful, but it works for me.

Please Login or Register  to view this content.

That's twice I had to fix your posts and add the CODE tags... (nudge)(poke)... you can do it yourself next time, ok? Take a quick gander at the forum rules you agreed to.