Hello All,

I am hoping there is someone out there that can help me with a macro I need to write. I am a macro / VBA novice!

I have a master file that creates a set of financial statements for a cost centre. I need a macro that copies this tab from the file, pastes it as values and formats into another pre-existing template file and then saves this template file based on the cost centre written in a particular cell and cost centre name written in another cell.

Any ideas? I've tried to record a macro whilst I do all this manually to get me started but to no avail!

Thanks!