Hello, i have a master excel template which users go in and save as when
completed.

Proposed macro - I want to create a macro for when pressed -

Save as a different excel sheet to a specific location and then hide
relevant columns and save the file as another name to a specific location.

I have tried to record a macro to do this but is doesnt work.

Help will be appreciated!!

Neil.

Please help.