Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
I am trying to update a lot of formulas on a worksheet with the same factor,
but I'm not sure if I have to update each and every formula, or if there is some way of doing a mass update in formulas? The normal find/replace doesn't seem to work! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
Provide a bit more detail,, actual data (sample), etc
"karin Harpering" <karin wrote in message : I am trying to update a lot of formulas on a worksheet with the same factor, but I'm not sure if I have to update each and every formula, or if there is some way of doing a mass update in formulas? The normal find/replace doesn't seem to work! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
In an empty cell enter the formula
=1.05 Not just the number 1.05! Edit|Copy Select your formulas Edit|Paste Special, check Multiply Try on a copy if your workbook first -- Kind regards, Niek Otten Microsoft MVP - Excel "karin Harpering" <karin wrote in message ... |I am trying to update a lot of formulas on a worksheet with the same factor, | but I'm not sure if I have to update each and every formula, or if there is | some way of doing a mass update in formulas? The normal find/replace doesn't | seem to work! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
For example, if I have the following cells: 1.2*1.05, 1.3*1.05, 1.4*1.05,
1.5*1.05, 1.6*1.05, and I now need to hang another *1.05 behind in each cell... Do I need to go into every single cell to do it? I can't copy and paste as the starting values are different, and replacing just part of the formula doesn't seem to work. Thanks a lot!! "JMay" wrote: Provide a bit more detail,, actual data (sample), etc "karin Harpering" <karin wrote in message : I am trying to update a lot of formulas on a worksheet with the same factor, but I'm not sure if I have to update each and every formula, or if there is some way of doing a mass update in formulas? The normal find/replace doesn't seem to work! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
You could use Edit Replace; Find: ~*1.05;Replace:*1.05*1.05
(remember * is a wildcard so use ~* to search for *) karin Harpering wrote: For example, if I have the following cells: 1.2*1.05, 1.3*1.05, 1.4*1.05, 1.5*1.05, 1.6*1.05, and I now need to hang another *1.05 behind in each cell... Do I need to go into every single cell to do it? I can't copy and paste as the starting values are different, and replacing just part of the formula doesn't seem to work. Thanks a lot!! "JMay" wrote: Provide a bit more detail,, actual data (sample), etc "karin Harpering" <karin wrote in message : I am trying to update a lot of formulas on a worksheet with the same factor, but I'm not sure if I have to update each and every formula, or if there is some way of doing a mass update in formulas? The normal find/replace doesn't seem to work! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I mass update formulas?
That worked - really easy, but I've never used that function before.
Thanks a lot!!!!!!!!!! "Niek Otten" wrote: In an empty cell enter the formula =1.05 Not just the number 1.05! Edit|Copy Select your formulas Edit|Paste Special, check Multiply Try on a copy if your workbook first -- Kind regards, Niek Otten Microsoft MVP - Excel "karin Harpering" <karin wrote in message ... |I am trying to update a lot of formulas on a worksheet with the same factor, | but I'm not sure if I have to update each and every formula, or if there is | some way of doing a mass update in formulas? The normal find/replace doesn't | seem to work! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions | |||
Printing formulas | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Excel formulas are slow to update | Excel Worksheet Functions |