D
ditchy
Hello, can anyone help me with this problem, I have a list of at least
50 names and I import a new event for them every week or so, I only
need a maximum of 5 (col E count)on the sheet. Would it be possible to
automate the deletion of the oldest date for each name so that there
is never more than 5 events for each name.Some names only have 1,2 or
3 events so no deletion is required until they reach 6 count
A B C D E
NAME TIME DATE EVENT COUNT
1 Cullen Chris 0:04:17 1/09/2003 Start H/caps 6
2 Cullen Chris 0:04:55 10/04/2004 Crater
3 Cullen Chris 0:04:36 22/05/2004 Vic Park Ccc
4 Cullen Chris 0:05:04 26/06/2004 Presidents
5 Cullen Chris 0:04:55 28/08/2004 FRONT&BACK
6 Cullen Chris 0:04:45 2/09/2004 middle
eg: remove row1, colA,B,C,D then move rows2,3,4,5,6 up one row to give
a count of 5.
All help is appreciated
regards
Ditchy
50 names and I import a new event for them every week or so, I only
need a maximum of 5 (col E count)on the sheet. Would it be possible to
automate the deletion of the oldest date for each name so that there
is never more than 5 events for each name.Some names only have 1,2 or
3 events so no deletion is required until they reach 6 count
A B C D E
NAME TIME DATE EVENT COUNT
1 Cullen Chris 0:04:17 1/09/2003 Start H/caps 6
2 Cullen Chris 0:04:55 10/04/2004 Crater
3 Cullen Chris 0:04:36 22/05/2004 Vic Park Ccc
4 Cullen Chris 0:05:04 26/06/2004 Presidents
5 Cullen Chris 0:04:55 28/08/2004 FRONT&BACK
6 Cullen Chris 0:04:45 2/09/2004 middle
eg: remove row1, colA,B,C,D then move rows2,3,4,5,6 up one row to give
a count of 5.
All help is appreciated
regards
Ditchy