Hi,

I hope some one can help.
I have created a spreadsheet to extract data and sort it into individual worksheets for the work, units and time individuals have done daily. This data is then copied to the bosses non modifiable spreadsheet.
My problem is:
I am trying to copy& paste data from my SS with formulas to to the other. The cells pasted into only have formatting of numbers and time) The pasted blank cells with "" criteria return a #value in the calculations column of the bosses. Can anyone help with a means of removing what I assume are non priting characters being pasted from my sheet. This is all currently done with macros, but do I need to take a different track.

Thanks

Geoff