What I would suggest is to write a Worksheet Change event handler procedure, something like this (at least it can be used as a starting point):
Some relevant information regarding the above procedure:
- Vendors will input data into cells D2:D1000 (this range calls the change event handler procedure)
- Vendor id is in column B
- Tracking numbers will be entered into column G
- In order to increment the tracking numbers, it is assumed above that data will be entered in row order. So if the same vendor enters different orders on the same date, the procedure will search up from the applicable cell to find the most recent order number, and increment it by 1.
HTH
Jason
Bookmarks