VBA macro to create new worksheet from existing worksheet

[YuthKu]

Hi, I need to create a new worksheet and call it 'PRICE' from the worksheet 'SETP 3' that I have,
And I need columns A, B, C, E, F, M, N of worksheet 'SEPT 3' to be the columns A, B, C, D, E, F, G in the new worksheet 'PRICE'

Could anyone please help write this macro for me.

Many thanks in advance

VKu

 

[Mike LH]

Hi,

Try this

Sub make_Copy()
Dim ws As Worksheet
On Error Resume Next
Set ws = Sheets("PRICE")
On Error GoTo 0
If ws Is Nothing Then
Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "Price"
Sheets("SETP 3").Range("A:A,B:B,C:C,E:E,F:F,M:M,N:N").Copy Range("A1")
Else
ws.Cells.ClearContents
Sheets("SETP 3").Range("A:A,B:B,C:C,E:E,F:F,M:M,N:N").Copy Sheets("PRICE").Range("A1")
End If
End Sub

 

[BlokeMan]

Cross-post;VBA macro to create new worksheet from existing worksheet

 

[Mike LH]

Cross-post;VBA macro to create new worksheet from existing worksheet

Thanks for that, the OP is clearly someone that believes their time is more valuable then ours.