Printing Macro

[Deleted]

I need to copy the data from one cell put it into another sheet in a specific cell and then print out that sheet. Is a macro the best way to do this? Ill have around 20 cells that will have will be sitting on the first sheet that need to be inputted to the printing sheet.

Thanks in advance,

Luke

[#2]

It depends, that could be drop-down list for the cell in second sheet based on cells in first sheet

[#3]

I have thought of the drop-down but I there could be issues with me missing one of the cells. I would then have to go through the list and figure out which one I missed.