Excel 2007 : print number sequence on 2 part ncr paper

print number sequence on 2 part ncr paper

i Am Looking For A Way To print sequential invoice numbers On Carbonless
paper. To Clarify, I Want To print Onto 2-part Ncr Paper, With The Number
incrementing Once Every second Sheet.

I'm looking for something similar, but with a numbers-and-text serial number, i.e. 033111BK01, 02, 03, etc.

I assume it will take some VBA or similar which I have no direct experience with, but I have done some programing in the past. A quick step by step how-to for this issue would be great, but I'm sure any help for either of us will be greatly appreciated!