ok, I've reposted this from the general forum http://www.excelforum.com/excel-gene...ber-on-it.html
as seems more suited over here!
I have a selected area which I print as labels.
I want to have a number on this label counting back from a number entered in a cell.
So if 300 is entered in cell N12 label shows somewhere 300, the 2nd label 299, the third 298 and so on.
Also ideally the number will be joined to cell K23 which is already subject to some formatting.
I would then hit macro for printing and select desired quantityto print.
I have stripped down my file for you to look at,
Many thanks for looking.
Bookmarks