Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to change linked formulas
I have linked formulas in several workbooks and sheets - I need to change one
of the line numbers in all of them - ..."\Monthly 2008\June 08\[1Charge Sheet.xlsx]Mon'!$B$5" - I need to change the 5 to a 6. Everything else stays the same - the Mon changes to each day of the week and the columns are the same on all the sheets. I used the Find and Replace - putting in "$*$5" will bring up all the ones I need to change (all of them came up in the find window) but I can not find a way to change them in the replace window. If I have to do this one at a time there could be as many as 400 entries - if I can do it by page there will be only 40 or 50 ... Please - can someone help me!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to change linked formulas
You have an answer in your duplicated post.
Pete On Jun 6, 6:31*am, jolowe wrote: I have linked formulas in several workbooks and sheets - I need to change one of the line numbers in all of them - ..."\Monthly 2008\June 08\[1Charge Sheet.xlsx]Mon'!$B$5" - I need to change the 5 to a 6. *Everything else stays the same - the Mon changes to each day of the week and the columns are the same on all the sheets. *I used the Find and Replace - putting in "$*$5" will bring up all the ones I need to change (all of them came up in the find window) but I can not find a way to change them in the replace window. If I have to do this one at a time there could be as many as 400 entries - if I can do it by page there will be only 40 or 50 ... Please - can someone help me!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!! Change a number in several linked formulas | Excel Worksheet Functions | |||
Help with linked formulas & multiple worksheets | Excel Worksheet Functions | |||
How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
linked worksheet formulas | Excel Worksheet Functions | |||
Can cells containing linked formulas be identified? | Excel Worksheet Functions |