Hi there,

I have a spreadsheet that has an entire database of tracking numbers that look something like this:

1-15-07-0185
1-15-07-0186
1-15-07-0187
1-15-07-0187.3
1-15-07-0188

But, we have a dashboard (called "Meter Closure Lookup") that only shows us the tracking numbers that match certain parameters and generates a new one. For instance, if the last one was "1-15-07-0188" then the new one is "1-15-07-0189" ([Zone]-[year]-[month]-[incremental]).

My code does that fine, but I'm trying to use it as a function instead of a macro, so when you put =TRACKINGNUMBER in a cell, the number generates, but since all the previous tracking numbers are on another sheets, the function just comes up as an error.

(The MeterID could be a six-digit number like 512512 or 519103, for example)

Please Login or Register  to view this content.