If Cell Equals X, Then Show Entire Row on Another Sheet.

I am desperate for help. I've tried and tried but cannot accomplish this.

In sheet "Projects", if any cell in column "J" equals "x", the corresponding row needs to be shown in another sheet, "FollowUp".
Once that the "x" has been removed from column "J" on the "Projects" sheet, that entire row needs to be removed from the "FollowUp" sheet.
I would like both the "Projects" sheet and the "FollowUp" sheet to maintain the same headers.

I don't mind using a button to do this.

Once that the "x" has been removed from column "J" on the "Projects" sheet, that entire row needs to be removed from the "FollowUp" sheet.
You mean entire row needs to be MOVED TO "FollowUp" sheet.

Put this code in to sheet "Projects". When you put x (Case senstive) in column J, the entire row will be removed and moved over to the other sheet.

Please Login or Register  to view this content.

When an "x" is present in column "J" on the "Projects" sheet, that entire corresponding row needs to be shown on the "FollowUp" sheet.
When an "x" is removed from column "J" on the "Projects" sheet, that same entire corresponding row needs to be removed from the "FollowUp" sheet.

No data is to ever change on the "Projects" sheet with the exception of adding and remove "x" from the column J and adding new projects.

That worked with the exception that when I remove the "x" from column "J" on the "Projects" sheet, it doesn't remove it from the "FollowUp" sheet.

But you are moving and remvoing the entire row to FollowUps, so which row or cell you want to remove it again from FollowUps sheet?

I removed the "Target.EntireRow.Delete" from the original code so that the original row was not removed from the "Projects" sheet and just copied to the "FollowUp". I just need it to recognize that when the present "x" is remove, the entire row that was copied to the "FollowUp" sheet that corresponds with the removed "x" is removed as well.