D
devens8765
Dear Members,
I have an interesting question related to the functionality of th
"replace" command. I have an Excel sheet that has links to anothe
Excel sheet in a separate file (or workbook). It is probably easier t
refer to the Excel sheet with links as the master sheet and the Exce
sheet to be read-in as the feeder sheet to avoid any confusion. I woul
like to replace some of the values in the master sheet with alternativ
values. However, it can't seem to find the values as the "look in
option in replace has only "formulas" as the option, but I can "find
the values by changing the "look in" option to "values" in the "find
command.
MY question is: is it possible to replace values in my master sheet?
Thanks for any help in advance.
Dav
I have an interesting question related to the functionality of th
"replace" command. I have an Excel sheet that has links to anothe
Excel sheet in a separate file (or workbook). It is probably easier t
refer to the Excel sheet with links as the master sheet and the Exce
sheet to be read-in as the feeder sheet to avoid any confusion. I woul
like to replace some of the values in the master sheet with alternativ
values. However, it can't seem to find the values as the "look in
option in replace has only "formulas" as the option, but I can "find
the values by changing the "look in" option to "values" in the "find
command.
MY question is: is it possible to replace values in my master sheet?
Thanks for any help in advance.
Dav