ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
hi Guys
=('R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$54+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$55+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$56+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$62)/'R:\Conso\A-conso\2015\03-15\[1
5Operating PL 31.03.2015.xls]YTD'!$D$7
i'm Triying to find and replace 03-15 to 04-15
and 31.03.2015 to 30.04.2015
however whenever I try to do any of these changes for example 03-15 to 04-15 first excel cannot find the file and automatically opens a window called "update vales in "15Operating PL 31.03.2015" for me to choose a file. Obliviously is not going to work as my find and replace is done individually and it there is not a file in folder 04-15 called 31.03.2015.
what is the way to
find and replace folder 03-15 to 04-15
and file 31.03.2015 to 30.04.2015 at the same time
I have a long column to amend
many thanks !
Antonio
=('R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$54+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$55+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$56+'R:\Conso\A-conso\2015\03-15\[15Operating PL 31.03.2015.xls]YTD'!$D$62)/'R:\Conso\A-conso\2015\03-15\[1
5Operating PL 31.03.2015.xls]YTD'!$D$7
i'm Triying to find and replace 03-15 to 04-15
and 31.03.2015 to 30.04.2015
however whenever I try to do any of these changes for example 03-15 to 04-15 first excel cannot find the file and automatically opens a window called "update vales in "15Operating PL 31.03.2015" for me to choose a file. Obliviously is not going to work as my find and replace is done individually and it there is not a file in folder 04-15 called 31.03.2015.
what is the way to
find and replace folder 03-15 to 04-15
and file 31.03.2015 to 30.04.2015 at the same time
I have a long column to amend
many thanks !
Antonio