[Solved] Copy two sheets data to new spreadsheet

[Lovepreet323]

How to copy two worksheets data to a new blank workbook using macro

[Villeroy]

viewtopic.php?f=21&t=77069&p=351686#p351686

[MrProgrammer]

copy two worksheets data to a new blank workbook

It's going to be difficult to save any time with a damned macro because the Edit → Sheet → Move/Copy dialog makes this so easy. You can select two sheets and copy them to a new document in about 15 seconds. And it might take you 10 seconds to start the Run Macro dialog and navigate to the right one. So you gain 5 seconds?

But if you really want one, just record a macro which executes those steps:
• Edit → Sheet → Select → select your two sheets → OK
• Edit → Sheet → Move/Copy → To document → New document → ✓ Copy → OK
• Stop Recording.

If you want to be able to choose which sheets are copied, omit that step from the recording. I decline to help further with this macro nonsense.