Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MS OS 2000 €“ MS Excel 2000
I have a workbook with 10 sheets. One sheet is the summary sheet; it contains links to most of the other pages in the workbook. I have a workbook like this for each month in the year. I need to copy the summary sheet from Januarys workbook to Februarys workbook and so on down the line. When I copy the summary sheet from one workbook to the other the formulas in the new sheet refer back to the original workbook. As the other workbooks already have data on the other 9 sheets and the summary sheet has many complex formulas on it, just copping the entire workbook over is not an option. I only want to copy the summary sheet. What needs to happen is the formulas need to copy exactly and not refer back to the original workbook. Thanks. -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
How to do the exact copy of a formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |