how to delete Rows in excel (row times: from~to)

[alimadhi]

hi , i want delete multi rows i have a lots of excels sheets recording time in Ms i want delete between Ms and keep them just every mint recorder

for example:- see blow recorder time in red mark

Time	dwatt2	L33TUC_FLT	l33tuc	DF	l20fa1x	hftout
30/08/2014 15:45	29.10786	0	0	49.17484	0	-5
30/08/2014 15:45	27.9434	0	0	49.19516	0	-5
30/08/2014 15:46	28.25409	0	0	49.21163	0	-5
30/08/2014 15:46	28.33318	0	0	49.2281	0	-5
30/08/2014 15:46	27.60696	0	0	49.23731	0	-5
30/08/2014 15:46	27.64434	0	0	49.2572	0	-5
30/08/2014 15:46	27.96513	0	0	49.27759	0	-5
30/08/2014 15:46	27.61231	0	0	49.29751	0	-5
30/08/2014 15:46	26.07797	0	0	49.33837	0	-5
30/08/2014 15:46	26.06944	0	0	49.36613	0	-5
30/08/2014 15:46	25.04375	0	0	49.40077	0	-5
30/08/2014 15:46	23.88965	0	0	49.41932	0	-5
30/08/2014 15:46	24.33256	0	0	49.44131	0	-5
30/08/2014 15:46	22.60748	0	0	49.45794	0	-5
30/08/2014 15:47	23.06262	0	0	49.47849	0	-5
30/08/2014 15:47	23.36586	0	0	49.48927	0	-5
30/08/2014 15:47	22.28431	0	0	49.49417	0	-5
30/08/2014 15:47	22.8875	0	0	49.50838	0	-5
30/08/2014 15:47	23.01399	0	0	49.51671	0	-5
30/08/2014 15:47	21.87897	0	0	49.54517	0	-5
30/08/2014 15:47	21.91144	0	0	49.56334	0	-5
30/08/2014 15:47	21.88628	0	0	49.57317	0	-5
30/08/2014 15:47	22.12372	0	0	49.58792	0	-5
30/08/2014 15:47	22.22739	0	0	49.59874	0	-5
30/08/2014 15:47	22.05495	0	0	49.6081	0	-5
30/08/2014 15:48	22.24202	0	0	49.61942	0	-5
30/08/2014 15:48	22.25443	0	0	49.62877	0	-5
30/08/2014 15:48	22.32067	0	0	49.63863	0	-5
30/08/2014 15:48	22.31877	0	0	49.64799	0	-5
30/08/2014 15:48	24.25901	0	0	49.65095	0	-5
30/08/2014 15:48	23.55493	0	0	49.64799	0	-5
30/08/2014 15:48	23.61375	0	0	49.64948	0	-5
30/08/2014 15:48	24.74718	0	0	49.65835	0	-5
30/08/2014 15:48	24.82937	0	0	49.66772	0	-5
30/08/2014 15:48	24.81699	0	0	49.67167	0	-5
30/08/2014 15:48	26.04348	0	0	49.67167	0	-5
30/08/2014 15:48	26.08807	0	0	49.67808	0	-5

<tbody>
</tbody>

to :-

Time	dwatt2	L33TUC_FLT	l33tuc	DF	l20fa1x	hftout
30/08/2014 15:45	29.10786	0	0	49.17484	0	-5
30/08/2014 15:46	28.25409	0	0	49.21163	0	-5
30/08/2014 15:47	23.06262	0	0	49.47849	0	-5
30/08/2014 15:48	22.24202	0	0	49.61942	0	-5

<tbody>
</tbody>

 

[alimadhi]

sorry for bothering you but i apricaite your help

i got this error

Run-Time error '1004':
Application-defined or object-defined error

 

[Rick Rothstein]

i got this error

Run-Time error '1004':
Application-defined or object-defined error

First off, tell me which line of code did the error occur on... when you clicked the Debug button, which line was yellow?

Second, when you posted this (which is what my code assumes your data looks like)...

now i have this below data:-

6/9/2014 11:04 AM	83.25909	0	1	50.61958	1	100
6/9/2014 11:05 AM	83.75203	0	1	50.60934	0	100
6/9/2014 11:06 AM	83.24986	0	1	50.56736	0	100

<tbody>
</tbody>

etc.

are the dates I highlighted in red in one or two columns?

 

[alimadhi]

My data now fine thank you for helping and if you can give me a macro for deleting rows every 10 mint see below data every 1 mint :-

6/9/2014 11:04 AM	83.25909	0	1	50.61958	1	100
6/9/2014 11:05 AM	83.75203	0	1	50.60934	0	100
6/9/2014 11:06 AM	83.24986	0	1	50.56736	0	100
6/9/2014 11:07 AM	81.60603	0	1	50.52342	0	100
6/9/2014 11:08 AM	80.89255	0	1	50.50097	0	100
6/9/2014 11:09 AM	82.85008	0	1	50.45663	0	100
6/9/2014 11:10 AM	83.65703	0	1	50.38697	0	100
6/9/2014 11:11 AM	83.41196	0	1	50.40373	0	100
6/9/2014 11:12 AM	81.49182	0	1	50.40831	1	100
6/9/2014 11:13 AM	82.60677	0	1	50.39205	0	100
6/9/2014 11:14 AM	82.19104	0	1	50.56174	1	100
6/9/2014 11:15 AM	81.55426	0	1	50.55765	0	100
6/9/2014 11:16 AM	83.80222	0	1	50.5643	1	100
6/9/2014 11:17 AM	81.37714	0	1	50.57759	0	100
6/9/2014 11:18 AM	82.50862	0	1	50.55765	0	100
6/9/2014 11:19 AM	81.1102	0	1	50.52904	0	100
6/9/2014 11:20 AM	83.64943	0	1	50.53772	0	100
6/9/2014 11:21 AM	83.55089	0	1	50.5224	0	100
6/9/2014 11:22 AM	82.44308	0	1	50.51525	0	100
6/9/2014 11:23 AM	80.98123	0	1	50.51219	0	100
6/9/2014 11:24 AM	82.01205	0	1	50.49434	0	100
6/9/2014 11:25 AM	81.75157	0	1	50.48567	0	100
6/9/2014 11:26 AM	82.40268	0	1	50.44594	0	100
6/9/2014 11:27 AM	81.54965	0	1	50.42406	0	100
6/9/2014 11:28 AM	81.64493	0	1	50.39611	0	100
6/9/2014 11:29 AM	80.73634	0	1	50.32915	0	100
6/9/2014 11:30 AM	79.99791	0	1	50.30181	0	100

<tbody>
</tbody>

I want to delete rows between (10 mint and 20 mint), (20 mint and 30 mint), ...etc to be like below :-

<tbody>
</tbody>

Time	dwatt2	L33TUC_FLT	l33tuc	DF	l20fa1x	hftout
6/9/2014 11:10 AM	83.65703	0	1	50.38697	0	100
6/9/2014 11:20 AM	83.64943	0	1	50.53772	0	100
6/9/2014 11:30 AM	79.99791	0	1	50.30181	0	100

<tbody>
</tbody>

 

[Rick Rothstein]

My data now fine thank you for helping and if you can give me a macro for deleting rows every 10 mint see below data every 1 mint :-

I did that in Message #10, but you said it did not work, so I asked you two questions in Message #12 but you have not answered them yet.

 

[alimadhi]

I did not see yellow line. Second, all my data deleted.