code to loop through column

Alan,

Thank you I think im beginning to understand... here is my sample worksheet. As you see its not much more indepth but.. is actually multiple SUIT items

You can see each date underneath the SUIt represents an item for that suit.. This is what I am wanting to copy and paste into its corresponding tab