I have the below code that will insert a blank row into my data based on a change in value in column 3, i need to alter this to look at column 3 and at a change in value count the number of rows above it and if divisible by 8 leave it as it is if not divisible by 8 then add enough blank rows so it is.
I want to use the data I have as a mail merge document into a label template that has 8 labels per page. and want to ensure that at a change in value in column 3 it goes onto another sheet of labels and this is the only way I can think of doing it other than scrolling down counting the rows and manually adding blank rows on a worksheet that has 1910 rows of data
Insert blank row at a change in value in column 3