automatically generate Sequential number when printing

[sgray1]

Hi There,

I am needing to print out approx. 100 copies of a despatch docket template, each with a new despatch docket number (as per below screen shot). Is there any function within excel that can automatically generate a new number in sequential order when printing? I am trying to avoid having to update the despatch number each time I print the document.

 

[johnnyL]

If vba code is an option, and 'Truck No' represents cell A2

Then Inside of a vba loop put:

Range("G3").Value = Range("G3").Value + 1