hello all,
I've searched the previous forum posts and the only reference I see to this seemingly simple problem uses exactly the approach that I cannot get to work.
I have a workbook with 2 worksheets. On sheet 1 (Roster) is a list of names; on sheet 2 (Summaries) is a set of calculations.
I want to create multiple copies of sheet 2 (Summaries) and name them according to the list of names on sheet 1 (Roster).
Creating and naming the worksheets appears to be working fine. The problem is that the worksheets that are added are blank, not copies of worksheet 2.
My code follows. Thanks in advance for pointing out my mistake.
Conor
Please Login or Register to view this content.
Bookmarks