Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook with 4 tabs. I want to be abl to change the formula
that is located in the rows on the 2nd tab and 3rd tab from 'networkdays' to 'nb.jours.ouvres'. What I would need to do is search the spreadsheet (workbook) for any references to 'networkdays' and replace it with 'nb.jours.ouvres'. The main reference area is on my tab called 'Retro'. Cell I4 to I43 contain the reference to 'Networkdays'. Here is the formula that I would want to change the networkdays to nb.jours.ouvres. English version: IF(AUTORATE!B8=0,0,IF(AUTORATE!$E$5="D",NETWORKDAY S (B4,C4)*G4/H4,NETWORKDAYS(B4,C4)*(H4/5)*G4/H4)) French version: IF(AUTORATE!B8=0,0,IF(AUTORATE!$E $5="D",NB.JOURS.OUVRES(B4,C4)*G4/H4,NB.JOURS.OUVRES(B4,C4)*(H4/5)*G4/ H4)) If this can be accomplisted, then it would be a matter of locating a button on the input section of my workbook and then it would work on both English versions of Excel and French versions of Exel. Many thanks Mel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Muliple formula conditions | Excel Programming | |||
formula reference~muliple sheets | Excel Discussion (Misc queries) | |||
Macro to change a formula to a value | Excel Worksheet Functions | |||
Macro To Change a Formula to A Value | Excel Worksheet Functions | |||
Change Formula with Macro | Excel Programming |