list unique substrings
 

Hi All:

I have several dynamic named ranges (DNR) that I copy from a datasheet
to a calculation sheet. I am attempting to build a matrix where the
row-headings are the first three characters of the first DNR and the
column headings are the last two characters of the first DNR. The
matrix would then populate using concatenate & vlookup.

Right now it is working using worksheet functions for the mid, concat &
vlookup. However, the number of observations I have is changing enough
that I would like to make it dynamic in VBA.

Thanks for your help.

James