My data transferred to the other spreadsheet with no problem, it lost the
format it had in the base spreadsheet such as dates, percentages, etc. The
problem is at the top of each of my columns it calculates totals and
percentages, and the total is counting all rows transferred whether they are
blank or not. I unclicked the "zero values" in the "Tools/Options" tab but
this didn't help. If I "clear contents" on the blanks cells the calculations
are correct but it also clears out the link to the other spreadsheet. One
other thing....there is a formula worksheet in the workbook that controls
calculations for some things (but not all). As far as I can tell this
worksheet isn't causing the "count the blanks" problem.