Auto Increment cell value with macro and print form

[parasnmehta]

Dear Mr. Excel.com,

My data is in sheet 1 in three columns:
Sr. Name Amount

(Sr. No. ranges from 10-500 in a sequence)

The format is in sheet2 where i get data using vlookup function (manually enter Sr. No. in cell A1 which is used as lookup value) and manually give print command for each data.

Please suggest me a macro so that the value in cell A1 in sheet2 is auto incremented, the data is fetched based on that value from sheet1 in the form and the form is printed for as many number exists in Sr. column.

Regards,
Paras