Hi I'm a complete beginner with macros, I have 8 excel report I do every week that use the same format and tabs, I want to automate this to save me some time, I have recorded a macro in spreadsheet but I keep getting run time error 1004, can you help me understand where I am going wrong please?