Copy paste data into new workbook

[Abhijeet]

Hi,

I have data in workbook with 4 worksheets i want to copy those data into new workbook with 2 worksheets( SF & EE) only this workbook save in desktop with current month name & year. can some one help how to create vba code for this

 

[Marc L]

Hi, unclear : share at least the exact expected new workbook name … New workbook still opened once done ?​

​

 

[Abhijeet]

Output file i attached

 

[Marc L]

The name was enough … Anyway according to the Macro Recorder a VBA procedure for starters :​

Sub Macro1()
    Sheets(Split("SF EE")).Copy
    ActiveWorkbook.SaveAs CreateObject("WScript.Shell").SpecialFolders("Desktop") & Format(Date, """\""mmm_yyyy "), 50
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​