If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Edit and Replace
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. -- Allan |
Thread Tools | |
Display Modes | |
|
|