Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to insert an addition to a formula across a worksheet. The cells
already contain a simple formula and I want to make the change without going into every cell and doing it manually. Can "find/replace" help do this or do I need a macro? What is ='4631-00'!D$71 ='4631-00'!e$71 ='4631-00'!f$71 should become ='4631-00'!D$71*c5 ='4631-00'!f$71*c5 ='4631-00'!f$71 *c5 +the 4631-00 is a sheet name and every row refers to a different sheet name +the insert (*c5) would need to adjust as it goes down the column (*c5,*c6,*c7,*c8 etc..) Thanks, Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Insert New Row without shifting formula | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
How do I insert the date using a macro | Excel Discussion (Misc queries) |