Want to write VBA code for:
If in column B, the cell include: "John" or "Mike"
then in column C:
Column C: includes link to other workbooks.
- The link should be updated with the following substituting:
- October substituted wih November:
and
-Actuals substituted with Forecast
Example of link:
h:/Germany/October/Reporting.xlsx.sheet_actuals!A1
(some of the links can have different names but the same principle for substitution should apply)
If in column B, the cell include: "John" or "Mike"
then in column C:
Column C: includes link to other workbooks.
- The link should be updated with the following substituting:
- October substituted wih November:
and
-Actuals substituted with Forecast
Example of link:
h:/Germany/October/Reporting.xlsx.sheet_actuals!A1
(some of the links can have different names but the same principle for substitution should apply)