Add vba to current macro to copy table into newly created sheet

Hi

I'm new to the forum, VERY new to using vba, but am experienced at using excel formula.

I'm using a macro to create new sheets based upon a list.
Sub Add_Tariffs()
Set Rng = Range("B3:B20")
For Each c In Rng
Var1 = c
On Error Resume Next
If Worksheets(Var1).Name = "" Then
Msg = "Worksheet named " & Var1 & " does not exist" & vbCrLf _
& "Do you want to add it?"
Ans = MsgBox(Msg, vbYesNo + vbQuestion, "Add Worksheet?")
If Ans = vbYes Then
Sheets.Add.Name = Var1
End If

End If
Next c
End Sub

What I need to do is copy a table from a 'Summary' sheet, paste it into the newly created sheet delete the data and then move on to the next.

If it's possible to include the newly created sheet in a calculation on the summary sheet too, that would be great, but I can write formula to pick that up.

Many thanks

Mark

after the Sheets.Add.Name line, add something like this?

Please Login or Register  to view this content.

Hi

I tried something similar but it wouldn't work.

Tried this and this wasn't working either...

Will have a think.

Thanks

Mark