I have been trying to figure this out for a while and searching for something similar. I apologize if I missed it somewhere but I'm getting frustrated. Here is what I need to do... We have work tickets that are 4 openings to a page. The amount of openings varies per job. When prompted for the number of openings in a user form I need to take that number and copy a range of cells for each of four openings (ie. 12 openings would copy the range of cells 3 times, printing 3 pages for the shop). However, some of the openings are the same and need to be put on the ticket as such. So, after being prompted for how many openings, the user is prompted for how many are duplicate and which ones. If there are duplicates the copy range will be less and if opening 4,5, & 7 are the same, I need those openings to appear on the same part of the ticket. The latter I think I can use a combo box that uses the result of the txtNumOpenings from 1 up to 52 and puts the choices in the proper place on the ticket as say 4,5 & 7 of 12. Any help would be greatly appreciated.

Thanks a bunch!
Kierstin