Delete Row Automatically

[abdullahsikandar]

Hi Guys,

I need a small help from you guys, I have a excel file where i am importing data from different files. What i need is to delete the whole row when the user write "Done" on the last column called 'AT'.

Like this:

Name ID Status

Abdul 1 Done
Rag 2 Done
Roh 3 Undone
Zai 4 Done

So the result would be like this

Roh 3 Undone.

When we run the macro.

Kindly help me in this matter.

 

[Oeldere]

@abdullahsikandar

please also add that you got an solution on the other forum.

 

[abdullahsikandar]

Thanks everyone for helping me. here is the Solved link.

http://www.excelforum.com/excel-programming-vba-macros/1005722-delete-whole-row.html

Thanks and sorry for all confusion.