Delete unneeded rows of data

Hi! all,

I have i data that i don't need in rows, so how can use the macro that just one click and then delete that rows out,
i have attached file:

Hi Yukioh. Welcome to the forum. Try this link to see if itis what you're looking for. http://www.excelforum.com/excel-prog...lank-rows.html

Try this one

Please Login or Register  to view this content.

Yuk,
You change this line, but you should have data in column "V"(2013/004")

From

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

this is every time i have to goto macro code to change it?

thank you so much mike... now it works

Hello

Another way to do this

Please Login or Register  to view this content.

Good Mike's code is working. Pehaps mine also works if I amend to this one

Please Login or Register  to view this content.