Hello,
Looking for a VBA solution that will look for unique names in column K and then create a new sheet for each name. My data set varies each week, and I am using UR = Activesheet.Usedrange.Rows.Count to determine the number of rows in the data set. I have a header row, which does not need a new tab name.
Thanks in advance.
Steve
Looking for a VBA solution that will look for unique names in column K and then create a new sheet for each name. My data set varies each week, and I am using UR = Activesheet.Usedrange.Rows.Count to determine the number of rows in the data set. I have a header row, which does not need a new tab name.
Thanks in advance.
Steve