Replace words in Formulas on a DashBoard worksheet
Paul Lautman wrote:
junoon wrote:
Hi All,
Does anyone know of a VBA procedure to Replace words in Formulas found
on a Sheet?
I have a Dashboard worksheet which has VLOOKUP formulas referencing
different fles which are according to months.
If i create a copy of the files & change their names to reflect the
current month, i have to go ahead & edit the Vlookup formulas on the
Dashboard worksheet to get data from the current month's files.
Since i file naming convention like:
XXXXXXX-May-06.xls
XXXXXXX-Jun-06.xls.....
Is there a VBA procedure which can look for May-06 & replace it with
Jun-06???
Warm Regards,
Junoon
What's wrong with Find & Replace?
I have around 300 cells referenced from 15 different workbooks & each
Vlookup done is for different types of Data (Numeric, Text etc).
|