In your sample file you have Shop Number 101 and Brand name ABC, will ABC ever appear with a different shop number like 102 ABC? Additionally will you ever have a blank shop number, brand name?
I am trying to accomplish very much the same thing with the exception of putting my data in a different workbook.
I will be finishing up my code this weekend, and will re-post Monday, hopefully with your feedback.
Bookmarks