Use a Macro to Copy/Paste and then Print

[groblerdn]

I have one work book which has two sheets. In Sheet 1 I have an existing template which has a cell address of B2.

In Sheet 2 I have a range of numbers, lets say the range is A1:A10. In each cell i have a different number for example:

A1 - 15
A2 - 20
A3 - 22
A4 - 28

ect.

I am wondering if there is a macro that will start at A1 on Sheet 2 and copy the number over to Sheet 1 B2 and print.

After that the macro must copy A2 on Sheet 2 and copy the number over to Sheet 1 B2 and print.

This must continue until the end of the range on Sheet 2 being A10.

Would really appreciate any help!