I am working on a spreadsheet to create 3-wide strips of paper that populates the fields based on pulling data from a "Data" worksheet. Basically, on the data tab, a patient name will be entered on each line and the proper values filled in by the user. The result on the "Tray Cards" worksheet will be a section for Breakfast, Lunch and Dinner for each patient. There will be up to 25 patients to manage on this spreadsheet so I am looking for an easy way to copy what is on the "Tray Cards" worksheet so that the final result will be up to 25 sets of the 3 wide strips. That will make sense when you look at the attached spreadsheet. I need to take what is already in there on the Tray Cards sheet and duplicate it 25 times. I know Excel tries to be smart when pasting cells with formulas and I don't want to have to manually fix all of the formulas that look to the Data worksheet to get values as I paste new rows but if this is the only way to do it, that is fine.
Tray instructions and Feed instructions will be hand typed in each cell as needed.
Also, when printing, if they have only five patients and they hit Print, is there a way to only have it print five pages of the possible 25 with no intervention? I don't want people to have to only print pages 1-5 because 9/10 people won't do that.
I am not a master of Excel and I am sure there is an easier way to accomplish my objective so I am open to any ideas.