I need a macro to insert blank rows after a unique record or duplicates, total of 8
Example:
If a unique record is found then insert 7 blank rows
If 3 duplicates are found then insert 5 blank rows
If 10 duplicates are found, keep the first block of 8 and then insert 6 blank rows
Ect..
Example:
If a unique record is found then insert 7 blank rows
If 3 duplicates are found then insert 5 blank rows
If 10 duplicates are found, keep the first block of 8 and then insert 6 blank rows
Ect..