I want to create folders based on entries in my worksheet. I can create folders but not the sub folders.

Folder path would be Current directory:\A1\B1\C1
Here is a sample of the data:

NORTHCENTRAL AVERY 212 PAD 802
NORTHCENTRAL AVERY 212 PAD 804
NORTHCENTRAL AVERY 212 PAD 810
NORTHCENTRAL BAKER 128D PAD 804
NORTHCENTRAL BAKER 128D PAD 810
NORTHCENTRAL BARBINE 292 PAD 420
NORTHCENTRAL BARBINE 292 PAD 422

So it would create c:\NORTHCENTRAL\AVERY 212 PAD\802
Your help is appreciated.