OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Thanks in advance for any suggestions.
How would I write the VBA Code to do the following:
I have a series of entries in a column which are in ascending order. When repeated I need to add a value to the first number and then the second, third, and so on. So for example, how do I write VBA code to go from the "Original" to the "Modified"
Original
Blue.2019.01.31
Blue.2019.01.31
Blue.2019.02.28
Blue.2019.03.31
Blue.2019.03.31
Blue.2019.03.31
Modified
Blue.2019.01.31_01
Blue.2019.01.31_02
Blue.2019.02.28
Blue.2019.03.31_01
Blue.2019.03.31_02
Blue.2019.03.31_03
How would I write the VBA Code to do the following:
I have a series of entries in a column which are in ascending order. When repeated I need to add a value to the first number and then the second, third, and so on. So for example, how do I write VBA code to go from the "Original" to the "Modified"
Original
Blue.2019.01.31
Blue.2019.01.31
Blue.2019.02.28
Blue.2019.03.31
Blue.2019.03.31
Blue.2019.03.31
Modified
Blue.2019.01.31_01
Blue.2019.01.31_02
Blue.2019.02.28
Blue.2019.03.31_01
Blue.2019.03.31_02
Blue.2019.03.31_03