Hi,
I have the following range in each cell:
='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2017 Daily Report\Daily Report\[Alor Setar.xls]Jan'!D4
I need to change the range to as follows:
='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2018 Daily...