Find cells with specific value -> select row and copy some cells into another workbook

[HePeoR]

Hi,

i have tried to pull this out with partial codes, but without success.

My file has in one column named "Diff", this cells have a formula inside. This formula gives me values. I'm searching for Zero values (there will be always several of those). If I identify a 0, than I need to copy 4 cells from the same row (columns A,V,R and D). In the end I have to copy them to another file.

Thank you for your time and help.

 

[sgroath]

In each of the cells that you are potentially copying data to, make it an if statement. For example, assuming your Diff is column W...
your target for the A column data in cell row 2 would be =IF(W2=0,A2,"")
your target for the D column data in cell row 2 would be =IF(W2=0,D2,"")
your target for the R column data in cell row 2 would be =IF(W2=0,R2,"")
your target for the V column data in cell row 2 would be =IF(W2=0,V2,"")

copy the formulas down the rows