Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have cells with diffent color fonts and need to total based on . | Excel Discussion (Misc queries) | |||
copying cells from other worksheets | Excel Discussion (Misc queries) | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions | |||
how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |