Hello,

I have Excel 2000 9.0, and I'm trying to copy several worksheets into one
file. I use the spreadsheets to do monthly budgets, so I have a month-end
worksheet, and weekly worksheets. The month-end worksheet uses sums of the
weekly worksheet. I would like to take all the "month end" worksheets into a
new file so I can calculate year end. I would like to transfer these totals,
but when I copy them into a new worksheet, all the totals end up being 0
since the equations don't work (it can't reference the weekly sheets for the
sums). How can I just transfer/copy these with the correct numbers?