FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I'm coding a macro that will insert a row where the text changes from one value to another. Here is a example:
I want to insert a row where the Shift value switches from 10A to 10B, 10B to 12A, and 12A to 12B, thus creating separation between the shifts. This is how it should look afterward:
Does anyone have any suggestions?
I'm coding a macro that will insert a row where the text changes from one value to another. Here is a example:
Name | Department | Shift |
Myah | OF | 10A |
Kenigia | OF | 10A |
Netta | OF | 10A |
Kendall | OF | 10A |
Andrew | OF | 10A |
Donnie | OF | 10B |
Summer | OF | 10B |
Shanika | OF | 10B |
Anthony | OF | 10B |
Kyle | OF | 12A |
Dustin | OF | 12A |
Arielle | OF | 12A |
Tony | Rec | 12B |
Josh | LDPA | 12B |
Jacob | OF | 12B |
James | OF | 12B |
I want to insert a row where the Shift value switches from 10A to 10B, 10B to 12A, and 12A to 12B, thus creating separation between the shifts. This is how it should look afterward:
Name | Department | Shift |
Myah | OF | 10A |
Kenigia | OF | 10A |
Netta | OF | 10A |
Kendall | OF | 10A |
Andrew | OF | 10A |
Donnie | OF | 10B |
Summer | OF | 10B |
Shanika | OF | 10B |
Anthony | OF | 10B |
Kyle | OF | 12A |
Dustin | OF | 12A |
Arielle | OF | 12A |
Tony | Rec | 12B |
Josh | LDPA | 12B |
Jacob | OF | 12B |
James | OF | 12B |
Does anyone have any suggestions?