Copying Excel Sheet for data that is reliant on an equation

[skoo]

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?

 

[dhstein]

Copy the original - and do a paste - special - values to a new worksheet.
You will get data only , no formulas

 

[Ron de Bruin]

Start here
http://www.rondebruin.nl/copy3.htm

Maybe you like the add-in