Paste Value

D

Dave

I am trying to copy cells O12:O25 and paste the value in cells U12:U25. The
problem is that I need to only paste the value of cells that have a number
in it on not the cells that have a value of "#N/A". I also have the same
problem in a different place but the value that I do not want to copy is
"#VALUE!".

Thanks
 
M

Mark

If you go back a step, you should look at the reason why
some cells contain #N/A and #VALUE. You can use worksheet
formulas (see ISERR and ISERROR) to ensure these do not
appear in your data. Then you will only see values.
 
D

Dave

How would do that?

These are the formulas

=IF(W12,W12,Y12)
=IF(U12,U12,X12)

Thanks a bunch :)
 
Top