Hi Jay

one option you might like to check out is using Pivot Tables with multiple
consolidation ranges - see the following web page for some details on this:
http://www.contextures.com/xlPivot08.html

Cheers
JulieD


"jay" wrote in message
...
if i have dates ...suppose feb 14 with the 3 on one worksheet and feb
14,feb
15 with values on a different worksheet. i just want sum for each date