Quote:
Originally Posted by rooly
The table you uploaded stops at 01-04-05 . How do I continue on to 01-05-01 Etc..
|
Limit1 or whatever it was (I don't have Excel currently so I'm not sure how I named them exactly) (at top of page are 3 limits, btw you can have them on separate sheet, or you can simply define them as names when those limits are fixed) determines the max number allowed in 1st 2 characters of code, and as result the range the formulas calculate the code for. So set the Limit1 to 99, and you get the max of the table with current Limit2 and Limit3.
Wait! At 01-04-05! I have to check the formula, but it takes some time. I have to connect to another computer.
It stops at 03-04-05 - what is right as Limit1=3, Limit2=4 and Limit3=5.