Can anyone help me with this? I'm sure there's a simple macro for it, but I'm not very good with them unless I'm recording. Basically, I'm doing staff rotas and looking for an easy way to show someone on leave. I could need to change many at the same time, so I'm looking for a bit of a time saver. So.....
Currently (Where selected Cell = A1):
A1 = 06:30
A2 = 13:30
A3 = 07:00
A4 = 07:00
A5 = BLANK
A6 = "TEXT"
A7 = "TEXT"
I want to change it to:
A1 = BLANK
A2 = BLANK
A3 = "00:00"
A4 = BLANK
A5 = "Leave"
A6 = BLANK
A7 = BLANK
Many thanks for any help
Currently (Where selected Cell = A1):
A1 = 06:30
A2 = 13:30
A3 = 07:00
A4 = 07:00
A5 = BLANK
A6 = "TEXT"
A7 = "TEXT"
I want to change it to:
A1 = BLANK
A2 = BLANK
A3 = "00:00"
A4 = BLANK
A5 = "Leave"
A6 = BLANK
A7 = BLANK
Many thanks for any help