AliGW
Thank you for the correction to the code I included, and I will remember for next time. So perhaps we can begin with how I believe my problem can be solved.
I have narrowed it down to just before filling the 2-d array "arr" from an already filtered pivot table.
In this pivot table are three columns of text; all similar to this arrangement - "61050 - Admin Gen Purpose". Obviously there are 1,000's of these category codes.
I need to test for the name of these three columns, when True, extract the first five digits of the string - then use that to fill the array.
Here is the code (lets hope I get these code-tags correct)
Well, I added my sample code "between" the code tags, so we'll see how it formats; looks terrible presently.
In any event, I believe just after the "For y = LBound(arr, 2) To UBound(arr, 2)" is where I should add the additional code.
Your guidance is most appreciated. Thank You.
Bookmarks