Hi, i've tried to do it, search through books and URL but couldn't find the
answer. Hope you guys can help.

I need to print labels to stick onto my packaging.

The conventional way is to have 4 labels in 1 sheet, then i print out 100
sheets and cut them out to make 400 labels and i have to write the number
from 1 to 400. It's very time consuming.

I was thinking is it possible to do it in excel such that i only have 1
label, then enter some formula, and when i print, it will auto print out the
quantity and the running number for me.