We help IT Professionals succeed at work.

Batch Numbering

Mnet Lub
Mnet Lub asked
on
82 Views
Last Modified: 2017-03-08
I have several columns withdata, but I want a VBA script that can copy the data from Column 9 (Job Numbers), put it in Column 1 (Batch Number) and create an automated batch number scheme starting at 20. If it search through the existing data and find a previous batch 20 it must mark the next one as 21 and so on....any ideas? eg. 15845-02-06/20....15845-02-06/21....15860-05-01/20, etc
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
upload a copy of the db with the related table.

Author

Commented:
Dear Ray ....please find attached the spreadsheet..... I have inherited the spreadsheets from a previous colleague with lots of errors....I can only do basic VBA so any help is highly appreciated. The lookup table needs to go into a separate spreadsheet but that will be done at a later stage....the VBA script is also not good. Any help will be much appreciated...Thank You!!
SBPS_Test.xlsm
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Dear Rey it is working perfectly, it is much appreciated!!! Thank You!!
CERTIFIED EXPERT
Top Expert 2016

Commented:
you are welcome, just don't forget to close the thread.

Author

Commented:
Great Stuff, thanks for all your help. Really Appreciated. Thanks !!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.