macro to create sheet from a workbook

[mart10]

I am using Excel 2013

I have a workbook and I need to export just one of the sheets into a saved sheet only with a name such as 'test' followed by suffixdd-mmm-yy and then close the sheet and then revert back to the workbook. Im ok at macros but doing this doesnt seem to work ie the logic (I haven't even tried the suffix yet so need answer on that also!)

Hope someone can understand what I am saying as difficult to put into words

 

[SkipVought]

Hi,

I posted this in you original post.


Turn on your macro recorder and record the following process:

Right-click the sheet in question and select Move or Copy..., Move selected sheets to (new book) and check Create a copy if you want to retain the original in the master workbook.

SavaAs the new workbook with the appropriate path, name and file type.

Close the new workbook.

Stop the macro recorder.

Alt+F11 will toggle to the VBA editor, where your recorded code resides in a Module. COPY the procedure and paste it here for help customizing.