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
Bookmarks