copying cells based on criteria

[tdro]

I'm trying to copy a row of cells based on two criterias on two columns
Basically, I'm trying to automatically copy an entire row of cells i
column A = "apples" or "Oranges" or "Peaches" etc and column d
"fruits", then I want Excel to copy the entire row and place it in th
same row where I am inputing the formula.

Also, I'm trying to input a formula where if column a= "apples" o
"oranges" or "Peaches' then column c should display "fruits"

Any help will be much appreciated.

Thanks in advance