Need macro that will update a sequential number field each time I print a form

**eradline** · 02-29-2012, 08:59 PM

Hello All,

I am new here and need some help as I do not know VBA. I have a basic template form that has a "batch number" field. My dept uses a lot of these forms so I need a macro that will print the form and then upate the batch number field with the next number that is listed in another column and then print again. It would also be helpful if I could specify how many copies I would like to print.

Any help would be greatly appreciated.

I have attached the basic form.

Thank you!

**davesexcel** · 02-29-2012, 09:11 PM

There is no attachment.

**jetted** · 03-01-2012, 09:48 AM

Hi

You will get a faster response if you attached a copy of your worksheets.

Thank

**eradline** · 03-01-2012, 05:55 PM

Sorry about that. Attached is the basic worksheet. I'd like for the Batch number field 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?