Hi guys, really hope someone can help.
I have a sheet of data, 2000+ rows and need to manipulate it in a variety of ways.
Basically I have a list of phone line information, broken down into half hourly increments over the course of a month and lists the relevant information across the rest of the colums.
What I need to do is delete every line where the time stamp is before 10am and after the last entry for 10.30am and do the same for 2 to 2.30 pm.
I've been doing this manually due to my lack of macro knowledge and I think I might be getting motion sickness so if anyone could lend a hand I'd be eternally grateful.
I realise my description may be a little vague so I have screenshots I could perhaps email people as my work firewall will not allow me to host the images anywhere.
Many thanks for any help,
Brian
I have a sheet of data, 2000+ rows and need to manipulate it in a variety of ways.
Basically I have a list of phone line information, broken down into half hourly increments over the course of a month and lists the relevant information across the rest of the colums.
What I need to do is delete every line where the time stamp is before 10am and after the last entry for 10.30am and do the same for 2 to 2.30 pm.
I've been doing this manually due to my lack of macro knowledge and I think I might be getting motion sickness so if anyone could lend a hand I'd be eternally grateful.
I realise my description may be a little vague so I have screenshots I could perhaps email people as my work firewall will not allow me to host the images anywhere.
Many thanks for any help,
Brian