Hi All:
I am struggling with replacing links. For example here is a sample link I want to modify.
'J:\Acc_Team\Send Reports 2006\Period 10\Week 1\[C_Buffalo_P10W1.xls
Picture this. I have a bunch of regions (i.e. Boston, Buffalo, Chicago etc) in Period 10 Week 1 folder on the J:
All I want to do is point the link to the Period 10 Week 2 folder. However, I have to do this one by one with the entire link (i.e. the sample).
I just want to selct an entire column and replace Week 1 with Week 2 and P10W1 with P10W2.
I also want to eventually replace Period 10 reference to Period 11. Does anyone know how I can do this.
When i select the cells I want changed and go edit links change source it changes everything on me.
Can someone help.
I am struggling with replacing links. For example here is a sample link I want to modify.
'J:\Acc_Team\Send Reports 2006\Period 10\Week 1\[C_Buffalo_P10W1.xls
Picture this. I have a bunch of regions (i.e. Boston, Buffalo, Chicago etc) in Period 10 Week 1 folder on the J:
All I want to do is point the link to the Period 10 Week 2 folder. However, I have to do this one by one with the entire link (i.e. the sample).
I just want to selct an entire column and replace Week 1 with Week 2 and P10W1 with P10W2.
I also want to eventually replace Period 10 reference to Period 11. Does anyone know how I can do this.
When i select the cells I want changed and go edit links change source it changes everything on me.
Can someone help.