Copying Excel Sheet for data that is reliant on an equation
 

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?

Copying Excel Sheet for data that is reliant on an equation
 

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


"skoo" wrote:

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?

Copying Excel Sheet for data that is reliant on an equation
 

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

Maybe you like the add-in



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"skoo" wrote in message ...
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?