How do I update the following formula for several worksheets within 2 files:
='E:\[Trending3a.xls]sheet1'!$J$1030
I have several worksheets within Trending3a and Trending3b, I need to add to this formula: from file Trending3b it is sheets 1,5,8,9 and 10-29 and from file Trending3a it is sheets 1,5,8,9 and 10-27, which have all been renamed.
='E:\[Trending3a.xls]sheet1'!$J$1030
I have several worksheets within Trending3a and Trending3b, I need to add to this formula: from file Trending3b it is sheets 1,5,8,9 and 10-29 and from file Trending3a it is sheets 1,5,8,9 and 10-27, which have all been renamed.