Macro which finds and copy's cells based on values in other cells.

I have the below code which works perfectly copying the values in range Ix:Kx from worksheet BPrices to Fx:Hx in worksheet BData IF the cells in both worksheets matches each other. Sometimes the values that are in BPrices Ix, Jx and Kx are 1.00. So it would copy 1.00 into BData Fx, Gx and Hx. I want it so that if Ix, Jx and Kx contain the same 1.00 in each cell then not co copy those cells. Possible?

Please Login or Register  to view this content.

Any ideas? I'd imagine it would require perhaps an If, Then function but can't write one that works at the moment.

This is my effort at the moment added in red font. If Ix =1.00 then I need it to skip copying that row and go to the next row.

Please Login or Register  to view this content.

I think I'm close now but just getting a Next Without For Error and the below code in red is highlighted.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I can get this code to run now but it still copies and pastes if the value is 1.00. Any help?

Am I missing an Else after <> "1.00" ??