Delete entire row based on cell value in another sheet

USE THIS CODE IN MACRO
ROW_1 = 1
COL = 1 ' CHANGE THIS AS PER YOUR ID COLUMN
ID = 10 'CHANGE THIS AS PER YOUR ID
Do Until Cells(ROW_1, COL) = ""
If Cells(ROW_1, COL).Value = ID Then
Rows(ROW_1 & ":" & ROW_1).Delete
End If
ROW_1 = ROW_1 + 1
Loop

Hi
you can use this

Please Login or Register  to view this content.

Cheers.

Please Login or Register  to view this content.

Uhmm. Almost the same as Post#4.

Please Login or Register  to view this content.

But this is a Sheet Event Code.

Originally Posted by prince141987

Hi
you can use this

Please Login or Register  to view this content.

I have tried, however, it shows an error. And when i debug, it highlighted the following bold coding

Please Login or Register  to view this content.

Originally Posted by prince141987

Cheers.

Please Login or Register  to view this content.

I have tried, however, it shows an error. And when i debug, it highlighted the following bold coding

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Uhmm. Almost the same as Post#4.

Please Login or Register  to view this content.

But this is a Sheet Event Code.

How am i suppose to make this event work? using the command button?

Originally Posted by Kamboj

USE THIS CODE IN MACRO
ROW_1 = 1
COL = 1 ' CHANGE THIS AS PER YOUR ID COLUMN
ID = 10 'CHANGE THIS AS PER YOUR ID
Do Until Cells(ROW_1, COL) = ""
If Cells(ROW_1, COL).Value = ID Then
Rows(ROW_1 & ":" & ROW_1).Delete
End If
ROW_1 = ROW_1 + 1
Loop

It says that the macro is not defined.

Hi DespoExcel,

Please this code :

Please Login or Register  to view this content.

Originally Posted by DespoExcel

How am i suppose to make this event work? using the command button?

Modified:

Please Login or Register  to view this content.

Originally Posted by jagadeesh.rt

Hi DespoExcel,

Please this code :

Please Login or Register  to view this content.

I have tried but it seem like there is no response when i click the command button

Originally Posted by JOHN H. DAVIS

Modified:

Please Login or Register  to view this content.

I have tried. The following coding that is bold is the result of the error - i debugged.

Please Login or Register  to view this content.

Do you have an Actual Sheet named "Database"? Check the spelling.

Originally Posted by JOHN H. DAVIS

Do you have an Actual Sheet named "Database"? Check the spelling.

yes there is

Can you attach a sample with some dummy data where it doesn't do what you require? I will load and test.