I have 83 workbooks with 5 sheets per book and 21 links per sheet - and I
need to replace - (basic link - ='C:\Users\Annette\Desktop\Annette Daily
Weekly\Daily\August\[1Charge Sheet.xlsx]Mon'!$B$12) - I need to replace the
month in every link. I know I can go page by page with find and replace but
I would like to know if there is any way to replace book by book. That would
mean 83 changes instead of over 400 - I am also very open to any suggestion
that would make this faster and easier. Thank you for any help you can give
me.