Automatically copy data from one worksheet to another based on a specific word entered

[arkadd61]

How would I Automatically copy a row of data from one worksheet to another worksheet if I enter a specific word/text in a cell? For example: I have "Worksheet1" & "Worksheet2". In "Worksheet1" I have 4 columns labeled "Date, Name, Status & Amount".

What I would like the formula to do is, if I enter the word "Schedule" in the "Status" column, I want that data in that row to automatically copy over to "Worksheet2" in the next empty row under the same title headings. I would also like it to automatically be removed if I change the word "Schedule" to anything else.

I hope this makes sense. I tried to attached a sample workbook, but I couldn't get it to upload for some reason. Thank you in advance for any assistance!

Semisi

[coreytroy]

When attaching, try the basic method.

[arkadd61]

How do you do that? I'm kinda new to all this.