Creating a Macro to Amend

[Jav_uk8]

Hi All,

I have a list of staff which varies from week to week and need certain elements amending such as changing the '/' to '-' for dates, replacing words and to minus 7 days from a date.

- Firstly I need the date format changing from '/' to '-' starting in column F2 (the amount will vary week to week).

- In column V2 and W2, I need the words replacing to 'Meat' (The words being replaced will vary).

- In column X2, there is a date in this column, I need the macro to minus (-) 7 days from the date in the cell (Dates will vary person to person).

Hope this makes sense.

Thanks

 

[Jav_uk8]

Re: Creating a Macro to Amend...HELP

Update:

I have sorted out the '/' to '-' issue with a macro.

I just cant work out how to replace different text in a column.