I would like to run a macro that performs the following action.
First I manually enter a product number such as 90-469-51-10 in some cell on the current worksheet.
This number entered before running the macro will always have the following makeup, i.e.
After running the macro the following numbers are generated automatically one after the other right below the first one that is entered manually (i.e. 90-469-51-10).
Each number generated will be in its own cell (rows).
The variable part of these numbers is the sixth and seventh number (in bold). the other numbers stay always the same
I came up with a formula solution but for some specific reasons I require a macro solution.
Help is very, very much appreciated. Thank you very much in advance.