Hello
I am new here, so I don't know how to ask this, I have a project of printing stickers the problem I have is changing the numbering
how to I create a macro that can change numbers as needed
examples
From 0001ART02 TO 999JKL10
without repeating any numbers
Hi,
It seems you are a describing a range with codes you provided.
I'd create a formula in Excel. And then use a exported CSV in a coreldraw merge later.
Not seeing your pattern exactly for when the letters would change sequentially.
the letters are supposed to change after every 500 numbers sequence
You can find and download my free macro Numeranger. Here is an example (gif-file) how to make numbering for stickers.
https://ibb.co/kBqP1Bd
Hey shark, I know this is a very old post. But I was wondering if you know where I could still find this macro? I have found it in Russian. Do you know where I can get an english version from?
Here it is an english versionhttps://www.youtube.com/watch?v=lWPhH3fF3ywEmail me at tv.softlv@gmail.comI will send you a gms fileRegardsTaras