Copying Excel Sheet for data that is reliant on an equation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skoo - 29 May 2008 20:02 GMT

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?

Reply to this Message

dhstein - 29 May 2008 20:11 GMT

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

> Hello,
>
[quoted text clipped - 6 lines]
> 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?

Reply to this Message

Ron de Bruin - 29 May 2008 20:13 GMT

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

Maybe you like the add-in

Signature

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

> Hello,
>
[quoted text clipped - 6 lines]
> 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?

Reply to this Message