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

Attached Files

Folder data.xlsx (8.7 KB, 9 views)