Macro to create folders based on content of a cell

Hi All,

I have to create 500+ folders that will be named the exact contents of a cell, an 8 digit account number and then a name.

I searched high and low for something but cannot find anything suitable.

It is basically a list in 1 column (A3-A553, at the minute). As a bonus if it could then display the hyperlink in the next column to the right that would be fantastic. I figure if it is a standalone tool it would be extremely versatile in other applications too.

If it were 20 folders I wouldn't be so bothered but 500 will mean at least 1 whole day of utter frustration.

(Future proofing it if it could ignore any already produced would be the icing on the cake.)

Any help would be greatly accepted.

Thanking you kindly

Michael, Leeds, UK