Sort data by given date

I would like a button that once pushed it delets all data on that row that is not between the dates chosen in cell G1 and G2 eg:
Rows 4, 11 & 12 would be deleted in this case. Column B4 down is the range

       A                    B               C             D             E             F                       G          
1                                                                                                           14/08/2011
2                                                                                                           16/08/2011
3
4     1      13/08/2011 12:38      1      0      1      0
5     5      14/08/2011 12:46      1      0      1      0
6     5      15/08/2011 12:46      1      0      1      0
7     5      15/08/2011 12:49      1      0      1      0
8     1      16/08/2011 12:49      1      0      1      0
9     5      16/08/2011 12:49      1      0      1      0
10    8      16/08/2011 12:27      1      0      1      0
11    1      17/08/2011 12:27      1      0      1      0
12    5      17/08/2011 12:27      1      0      1      0
RobJanineAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
wchhConnect With a Mentor Commented:
try the attachment...
delete-rows.xlsm
0
 
RobJanineAuthor Commented:
Sorry, also once above complete then sorted into days and number in column A, and remove columns C,D,E & F   eg: (EG with more data than above)

4     5      14/08/2011 12:46    
5     5      14/08/2011 17.48
6     5      15/08/2011 12:52    
7     5      15/08/2011 18:49  
8     5      16/08/2011 10:49  
9     5      16/08/2011 17:27  
10   7      15/08/2011 09.25
11   7      15/08/2011 14.32
12   7      16/08/2011 08.25
13   7      16/08/2011 15.32
14   7      17/08/2011 09.06
15   7      17/08/2011 14.54
16   9      15/08/2011 09.12
17   9      15/08/2011 14.45

I hope this makes sence.....

Cheers

Rob
0
 
RobJanineAuthor Commented:
Thanks so much....perfect!

watch out because I will have more questions while building this excel sheet tomorrow.

Thanks again

Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.