Sorry for the confusion Bob,
Maybe I should have left that part out...
After the data is in the format like that shown in my previous post I copy and paste it into another workbook that creates the folders and sub folders (that part works well).
So if we forget about how I intend to use the end result, my problem is....
I usually start out with a contiguous list of unique Plan Numbers.
I then add the PN text and pad the number part with leading zeros so it is PN followed by five numbers or nine numbers.
The question I was trying to pose is how to add the name from column A as a prefix to at least four entries (which would eventually become the sub folders).
A have attached a workbook with a very basic example, where column A is the padded contiguous unique data. In column C I have (currently) just copied and pasted this to every fourth row.
I have attached a very basic mockup copy if that helps.
I hope this makes more sense.
Regards, Dave T
|