Hello all. Is there a way to use an IF statement to copy multiple cells onto another sheet? I have data across 4 cells (multiple rows) and need to omit the rows that have a zero value in any of the 4 cells.
I am using columns A thru D and columns B and D will be the ones that sometimes contain a zero value. I need to copy over the rows that contain data across all 4 cells only. I am trying to filter but am not having much luck. Thank you.
I am using columns A thru D and columns B and D will be the ones that sometimes contain a zero value. I need to copy over the rows that contain data across all 4 cells only. I am trying to filter but am not having much luck. Thank you.