It would not be hard to copy and paste, just tiresome. This is more for
future reference.
I think I will give Bob Phillips formula a try and see how that works.

As far as masking all errors, I am not worried about it for this sheet as
the blank cell is the only thing that would cause the error. ONce that is
filled everything else works.
Normally if it were just for me, I would leave it alone knowing that a value
in JF would eventually solve the problem. However this is for others in the
office to use later and I don't need a hundred emails telling me that the
sheet has an error before they fill in cells.

Thanks for all the help!!

Neil