Hi Excel experts.

I want to be able to generate some Labels for printing.
I have an Avery add-on to Word that will Import a list of numbers from
an Excel sheet, and then arrange such that they then print out 48
labels per A4 sheet.

I'd like to be able to generate automatically the column of numbers to
achieve this, by Inputting the number of sheets (so if you pick 2, 96
numbers are generated etc) and another number which is the Prefix (a
branch code)

So the list would look like
List
K81011_001
K81011_002
etc.
etc.

As an alternative, the second number could be the actual total of
lines to generate instead of multiples of 48

Thanks for any help here. (Complete Macro/VBA novice)

Neil