| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retain formatting of Excel sheet when copying data into it | Excel Discussion (Misc queries) | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Copying Data from one sheet to another sheet on a specific day | Excel Worksheet Functions | |||
| Stop excel from copying data from one sheet to another | New Users to Excel | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Linear Mode
