I have a spread sheet with various product reference numbers and stock levels.
This is in excel in two columns.
What I need is to set up some sort of macro that creates a reference number for each of the quantities.( i.e: 3 entries for REF 100, 4 entries for REF 101 etc)
So for example, would create another sheet that shows the following :
I need to print a label for each reference number for each individual stock item.