copying cells based on criteria
 

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 if
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 the
same row where I am inputing the formula.

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

Any help will be much appreciated.

Thanks in advance.


--
tdro
------------------------------------------------------------------------
tdro's Profile: http://www.msusenet.com/member.php?userid=2199
View this thread: http://www.msusenet.com/t-1870538184