Vba - create new sheet and copy date into it.

[zerofeng]

Hi,

I would like to seek advice of below vba.

The code will auto create new sheet with the name from a3 cell under master sheet. The master list data will be append data for every month. From the code below, I'm not able to copy the data after generate new sheet with subsequent month as the paste value sheet is still under the same month.

a3=dropdown Month Eg JAN24, FEB24
Master D1: M+++(data will be updated each month)

Sub create ()

Dim Master As Workbook
Set Master = Workbooks("create sheet 1.xlsm")

Sheet.Add(After:=Sheets(Sheets count)).Name = Master.Worksheets("MASTER").Range("a3').value

Master.Worksheets("MASTER").range(D1:M7).Copy
Master.Worksheets("JAN24").Range("D5:AH17").PasteSpecial

End sub

 

[zerofeng]

Sorry wrong subject. It should be Vba - create new sheet and copy data into it.