In a spreadsheet i have the following
A B C D
- Absent until further notice
20005 0 Absent until further notice On Off
20005 1 Absent until further notice Allow crew
20005 4 Absent until further notice New absences
20005 5 Absent until further notice Cut off times
- Afternoon shift allowance
102 0 Afternoon shift allowance On Off
102 1 Afternoon shift allowance Min start time (HH:MM)
102 2 Afternoon shift allowance Max start time (HH:MM)
102 3 Afternoon shift allowance Allowance (cents)
- Agents Point Counter Settings
20024 0 Agents Point Counter Settings On Off
20024 2 Agents Point Counter Settings Work a public
20024 3 Agents Point Counter Settings Other Holiday Points
20024 4 Agents Point Counter Settings Holiday on day off points
20024 5 Agents Point Counter Settings Public Holiday
20024 6 Agents Point Counter Settings Expiry Period (Years)
Column a will only have the "-" in it to signify that this is the TITLE as shown above
At present I manually go through and GROUP these so that the TITLE only is visible
- Absent until further notice
- Afternoon shift allowance
- Agents Point Counter Settings
The problem is that everynow and then I need to either add or update these rows so I must UNGROUP then fix everything and then GROUP again.
Is it possible to run a code on Column "A" find any "-" references then have what is under neath grouped until the next reference is found
Start Free Trial
