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 |
All times are GMT +1. The time now is 10:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com