Formula to copy a row of cells from on worksheet to another if a certain word is 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 to automatically copy over to "Worksheet2" in the next empty row. 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

[arlu1201]

A formula may not be able to help you in this but a macro surely can. Would you be open to a code solution?

[L-Drr]

Looks like you don't neccessarily need to copy the data, but only to display them is you ask for it (by typing "Schedule").

For explaning purposes let's say the following:
- The original Status data are in Worksheet1 C3:C10.
- The field where you want to type "Schedule" is in Worksheet1 C2.
- The range where you want the data to copy to is in Worksheet2 A3:A10.

Type the following in Worhsheet 2 A3: =IF(Worksheet1!$C$2="Schedule";Worksheet1!C3;"")
When you copy this formula downwards untill A10, you should get the desired results.
You can expand this formula with other options (instead of "Schedule") by writing extra IF functions within the function above in the "value is false" section.

If I have understood your problem correctly, this should give you a right basis to solve it.
So... does it?