I am trying to find a way of getting excel to automatically save a finished file under a different name. i.e. the same workbook master is used each week with fresh data being added to it by various heads of department, the file is then saved under a different name (usually the department name & then date) and sent for processing by a finance dept. Is there anyway of automating this process so the saved name is uniformed across departments? A lot of these workbooks are used by different departments and this is a way of organising a group of files into a logical order to be processed by finance.