M
mulr1966
Hello everyone, I have searched for an answer to this question and hav
not found anything close to it. so here goes,
I have approx 300 plus formulas on a single sheet workbook. I woul
like to change all the formulas either through the find / replac
method and substitue them with variables. For example
COUNTIF('C:\Transfer_reports\Robert_old\[NEW_Transfer_LOG_CLOSED.xls]Octobe
2003'!$F$26:$F$197,"OPD FDR")
The above formula has multiple sections that would need to b
substituted such as
C:\Transfer_reports\Robert_old\
would now be PATHVALUE
NEW_Transfer_LOG_CLOSED.xls would now be MMMM_YYYY_ts.xls
and
October 2003 would be SHEETNAMEVALUE
When I try to do the Find / replace and have
C:\Transfer_reports\Robert_old\ in the find box and PATHVALUE in th
replace box I get a message saying that Excel cannot find any data t
replace .... any idea what I can do ro why this is happening ?
Thank you for any assistance.
Rober
not found anything close to it. so here goes,
I have approx 300 plus formulas on a single sheet workbook. I woul
like to change all the formulas either through the find / replac
method and substitue them with variables. For example
COUNTIF('C:\Transfer_reports\Robert_old\[NEW_Transfer_LOG_CLOSED.xls]Octobe
2003'!$F$26:$F$197,"OPD FDR")
The above formula has multiple sections that would need to b
substituted such as
C:\Transfer_reports\Robert_old\
would now be PATHVALUE
NEW_Transfer_LOG_CLOSED.xls would now be MMMM_YYYY_ts.xls
and
October 2003 would be SHEETNAMEVALUE
When I try to do the Find / replace and have
C:\Transfer_reports\Robert_old\ in the find box and PATHVALUE in th
replace box I get a message saying that Excel cannot find any data t
replace .... any idea what I can do ro why this is happening ?
Thank you for any assistance.
Rober