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

[Bkisley]

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?

 

[Bkisley]

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!