I have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade
=PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08/19;3;True;False", "10")
i want to be able to change the dates all at once, i have the 2 cells setup the values I want to look for are in M8 and M9 and i want to replace it with the values in L8 and L9 respectively and this works fine anywhere in the spreadsheet except in the above formula for some reason it won't look through the formula for it the following is the code I am using.
You copy this value, but never paste it and same with next block with L8. May be code is not needed or maybe you forgot to paste. The reason you are not able to replace it because, the date that is in formula is in format YYYY/MM/DD. The date that you are searching for is not in that format. So you need to add one more search and replace where you search for date in YYYY/MM/DD format and replace in same