Copy and Paste Macro

[mdlyzinski]

Hello, first time posting.

I wanted to create a macro to make copying and pasting formats and values easier.

Here's what I want to do with the click of a button:

- Copy from two tabs of active worksheet

- Create new worksheet

- Paste values and formats to new worksheet for each tab

- Save as current date in ddmmmyy format + standard text (ex: "02DEC13 Spreadsheet Name")

Thanks