Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit several formulas at one time in a worksheet?
I have a workbook that contains a daily report. I add a new sheet for every
day of the month and right now I have to change all my formulas to reference the day immediately before individually. Does anyone know of a way to edit several formulas at one time to reference the sheet before them after copying the entire sheet for a new daily report? The formula I am using is a 3D reference formula that brings information from the previous day to the current day. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
edit formulas on a worksheet simultaneously? | Excel Worksheet Functions | |||
How can i Edit many Cells at a time. | Excel Discussion (Misc queries) | |||
Some more help to edit some formulas | Excel Worksheet Functions | |||
Edit Paste Special Formulas | Excel Worksheet Functions | |||
hide formulas but can edit on the same cells | Charts and Charting in Excel |