I have attached 3 examples for reference, Sample A is with the macro run with no data in sheet 2 with I in column A, Sample B is macro run with I occurring once in sheet 2 column A and sample C is macro run with I occurring twice in sheet 2 column A.Hope this helps and if you need anything further please let me know.
Bookmarks