Consecutive numbering using VBA

[litestream]

I have 2 worksheets - called "Data" and "Labels"

The "Label" worksheet is in fact a label which is affixed to a pallet for delivery. Each label says "pallet x of y" where "y" is the total number of pallets and "x" is the number of the pallet.

"x" is a fixed number which I enter into cell A1 of the "Data" worksheet (usually 1 unless I have to stop the printing and resume at a later time)

"y" is the total number of pallets for the delivery and is taken from cell B1 of the "Data" worksheet but is the result of a formula which works out the number of items on each pallet.

On the "Label" worksheet, cell C1 is the pallet number and C3 is the total number of pallets

How can I print out consecutive numbered labels? I know it's part of a "for next loop" but I'm unsure how to do this in VBA.

Any assistance would be greatly appreciated.

 

[Peter_SSs]

litestream

See if this might be adaptable to your situation:
http://www.mrexcel.com/board2/viewtopic.php?t=237319

Post back if it is not or if you need help to modify.

 

[litestream]

Thanks a lot, that was perfect.