Delete Line in Different Sheet Based on Cell Value and IF Statements

[jhar123456]

I currently have a worksheet which consists of multiple sheets. On sheet "Imp. and Def. Rank Template" I enter in information which is all based on the entry number (Cell "B2") and then have a properly functioning macro which will do 1 of 3 actions depending on IF statements:

1) If the entry is new (Sheet "Imp. and Def. Rank Template" Cell "E2" and "E4" are blank), take the information and post it on sheet "Open Imp. and Def." where appropriate (already coded properly).

2) If the entry is updated (Sheet "Imp. and Def. Rank Template" Cell "E2" is populated but "E4" remains blank), take the information and post it on Sheet "Open Imp. and Def." where appropriate.

3) If the entry is closed (Sheet "Imp. and Def. Rank Template" Cell "E4" is populated), take the information and post it on Sheet "Closed Imp. and Def." where appropriate.

The function that I would like to add is a line to each of my IF statements that says if #2 above is performed, then the original entry (based on the name in Cell "B2") on the same sheet will be deleted. Additionally, if #3 above is performed, I would like the entry (based on the name in Cell "B2") on "Imp. and Def. Rank Template" to be deleted.

Being new to VBA, I would sincerely appreciate any help on this issue. Thank you!