Very simply, my question is this...

I want to try to use M EX to create tags for the parts we make during the
manufacturing process. The tag would have some standard information about
the part on the tag...

The problem being that I have a formula (that works) for creating the
sequential next tag # (0001, 0002, 0003, 0004...etc). The problem is that we
have hundreds of boxes and that it would take days/weeks to manually make a
tag for each box.

Now I've tried using copy/paste but the problem is that the formula
constantly looks for information in the wrong cells and that means manually
changing the tag # cell of each tag manually. (I have to change 4 different
cell references per tag).

Is there an easier way to do this?

Each tag takes up a space the size of A1-G12. The tag # reference cell is G8.
The formula I've been using is "=IF((G21-G7=1), G21+1, G21+2)" with the
first tag ref # being 1000 and the second being 1001.

The tag # always references the 2 tag # before it.

Any help with this is greatly appreciated.

Sincerely,
Andrew M.