You know I actually started making this tutorial with that in mind but thought that it might be easier to follow without it, but maybe you are right. I will at some point do a larger tutorial just for that topic though but it will end up rather specific, especially once I throw in arrays.
Yes, but you need a macro for that. I suggest that you get a sample file setup and figure out exactly what you require and then try to go step-by-step to figure it out and ask for help along the way in TeachExcel's forum (but please do not demand someone do the work for you, you will still have to try): www.teachexcel.com/talk/microsoft-office?src=yt_comment