VBA That Creates New Tabs for Specific Values BUT ignores one Value

Bkisley

Board Regular
Joined
Jan 5, 2017
Messages
94
Hello Geniuses!

I have a code that refreshes my pivot table of names, copies a blank template, adds a new tab based on the values in that pivot table, and names each new tab the unique name from the pivot table. My issue is that since I am using a pivot table, it is pulling that columns header which is unable to be deleted. So when I run this macro, I get a new tab called "Client Name" aka the header of that pivot table column. I clearly do not want this. Am I able to ignore "Client Name" or start in Cell A2 to end of pivot table?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Bkisley

Board Regular
Joined
Jan 5, 2017
Messages
94
I'm not sure how to delete this but I figured out the answer....In case anyone has the same problem and have the following in your code

For i = 1 To LastRow

All you have to do is change that 1 to a 2 and you're golden!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,788
Messages
5,574,280
Members
412,584
Latest member
Leow
Top