F
Flipper
The edit and repalce function is not working liek I think it should. I have
one workbook with multiple worksheets in it. Each month I copy the prior
month's worksheet and then rename it to the current month. I have a check
request that has links to these monthly worksheets. When I try to update the
links, Excel forces me to navigate through my directories until I come to the
workbook I am in, which is already open, and then click on the name of the
workbook before it will update the link. I. E. I want to replace the "Mar"
in "Mar 10 Fees" with "Apr". If this were just one cell, maybe that would be
okay but it is 30 cells, and to have to navgiate through my directories for
every cell I want to update, doesn't seem right.
Any help is appreciated.
one workbook with multiple worksheets in it. Each month I copy the prior
month's worksheet and then rename it to the current month. I have a check
request that has links to these monthly worksheets. When I try to update the
links, Excel forces me to navigate through my directories until I come to the
workbook I am in, which is already open, and then click on the name of the
workbook before it will update the link. I. E. I want to replace the "Mar"
in "Mar 10 Fees" with "Apr". If this were just one cell, maybe that would be
okay but it is 30 cells, and to have to navgiate through my directories for
every cell I want to update, doesn't seem right.
Any help is appreciated.