jrosen
08-27-2019, 05:02 AM
I'm new to VBA, and not sure where to start on this...
I need a code that will look at the month of the system date and take ONLY 9 numbers from right of invoice # (column K) and concatenate it with a letter based on what month it is. For example:
Invoice 0123456789
(For August, letter "H" is concatenated, for September it is "I", and so on).
After macro: 123456789H
I would like this to continue down the entire column until it reaches the end
I need a code that will look at the month of the system date and take ONLY 9 numbers from right of invoice # (column K) and concatenate it with a letter based on what month it is. For example:
Invoice 0123456789
(For August, letter "H" is concatenated, for September it is "I", and so on).
After macro: 123456789H
I would like this to continue down the entire column until it reaches the end