Hi, I have two worksheets, let's call them #1 and #2, both have multiple
worksheets which are linked to other worksheets in the same workbook. I want
to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2.
All numbers get copied fine except for the date. So, for example, when I copy
the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all
the other dates. I've checked the formatting and all but can't figure why the
date would not copy exactly.

One thing that may be affecting this is that the two worksheets were
constructed on different computers...but dunno why that would make any
difference. I've even saved both files as "Macro-Enabled" but to no avail.

I'm stumped...would appreciate help. Thanks!

rooter