How well do you know VBA? What you're asking is of moderate difficulty. If you don't know it well, we are here to help.
The first thing to do is set up your spreadsheets. It would be a good idea to include some sample data, and how you expect it to look on your sheet that has the teams posted. Once you have this set up with some sample data, post it here and we can either give you advice for how to code it, or if you'd like we can code it for you.
Bookmarks