| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carrying formulas from one sheet to the next within the same file
I have 52 tabs set up, one for each week of the year. I enter data in the
top of my grid on one sheet and I want it to add it to the cumulative total below. Each week I want to copy and paste the grid with formulas to the next week (worksheet) but it is not carrying over the formulas. I have the name of the referenced sheet in quotes in the formula. How do I overcome this so I do not have to plug in the formulas every week? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carrying over formulas into newly inserted row | Excel Discussion (Misc queries) | |||
| Carrying format with cell reference to another sheet. | Charts and Charting in Excel | |||
| carrying over a column formula from one sheet to another copied sh | Excel Worksheet Functions | |||
| carrying entire row to another sheet using vlookup | Excel Discussion (Misc queries) | |||
| Moving a file without carrying over permissions | Excel Discussion (Misc queries) | |||
Threaded Mode
