hi p45cal
is it possible to do this ,when 1time run the code then
if within finding "." row "per group" if Weekly is 3 time then change to 4 go to next group of row if weekly is 4 time then make it to 5 time and if it is 5 then make it 6 time and if it is 6 then do nothing .hope i explained it right.
I see you put the count in column M before you make changes; do you want this to be after you make changes instead?
that i was looking for how many "Var" found in each group and how many change have be made .that data is not needed one it work with sample data

Is the change to 4, 5 or 6 for the whole sheet or per group on the sheet? Do you want to ask the user what the limit is each time?
it's per group and if it ask the limit each time is batter too so i don't need to change the code each time if limit chage