Good luck. Something like this will involve some heavy programming. And this is another example of something that should be done in Microsoft Access using two tables.

Mauricio made another thread on this topic which I answered:

https://599cd.com/blog/display-article.asp?ID=352&CommentID=64407

Awesome. Good solution. Much easier to do in Access than in Excel.

This is what happens when I move and I'm 45 days behind on the Forums. LOL