Hi I am hoping someone can help

Please Login or Register  to view this content.
The above code saves the sheet I need into another file but I need to expand it so that it modifies the data when saving
I need it to unhide columns, Find and replace Particular capital letters with words, and change the validation on some columns
How would I modify this macro so it can do this?

Any help or suggestions welcome