PhosFeedLogisticsMan
New Member
- Joined
- Aug 9, 2017
- Messages
- 17
Still new and still learning, I am close, but can't figure out how to get this to work the way I want. Here is what I have:
What I really need is the following, but I don't want it renamed as "Vendor Scorecard2" which is a duplicate of my second sheet.
Basically trying to get this second part to loop through the sheets instead of copying and pasting date from a range as in the first example. I need it to look exactly as my "Vendor Scorecard" template(Sheet 2).
In short.... exactly duplicate a sheet called Vendor Scorecard, and paste it into multiple worksheets that follow that sheet all which have different Vendor Names. Make sense? So close, but can't figure out how to to do it.
Code:
Sub copytemplate3()
Dim WS_Count As Integer
Dim I As Integer
WS_Count = ActiveWorkbook.Worksheets.Count
Dim Source As Range
Set Source = ThisWorkbook.Worksheets(2).Range("A1:N26")
' Begin the loop.
For I = 2 To WS_Count
ThisWorkbook.Worksheets(I).Select ' just select the sheet
Source.Copy
Cells.Select
ActiveSheet.Paste
Next I
End Sub
What I really need is the following, but I don't want it renamed as "Vendor Scorecard2" which is a duplicate of my second sheet.
Code:
Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Worksheets("Vendor Scorecard")
ws1.Copy ThisWorkbook.Sheets(Sheets.Count)
Basically trying to get this second part to loop through the sheets instead of copying and pasting date from a range as in the first example. I need it to look exactly as my "Vendor Scorecard" template(Sheet 2).
In short.... exactly duplicate a sheet called Vendor Scorecard, and paste it into multiple worksheets that follow that sheet all which have different Vendor Names. Make sense? So close, but can't figure out how to to do it.