Need macro to update a number field each I print a form

[eradline]

I could really use some help with a macro. I'd like for the Batch number field in the attached worksheet to update with the next sequential number in Column M each time the form is printed. Don't know if it would also be possible to specify the number of printouts in the macro?

Thank you to anyone who could provide some assistance. I have no knowledge of VBA. Also, can anyone suggest a good book to learn VBA for Excel / Access?

Thanks,
Erick

[snb]

If cell D4 contians the number of prins:

Please Login or Register  to view this content.

[eradline]

Sorry. This is not what I'm looking for. I need cell G9 (Batch Number) to start with the first number in Column M for my first printout and for each copy that is printed, cell G9 needs to update with the next sequential number in Column M so that each printout has a sequential batch number.