formula to automatically print the number of skids based of the total

[gweitzel81]

PACKAGES 50 TOTAL WIGHT 500


SKID 1 OF 6



I have 6 skids and the the weight is the same and sometimes the weight is different but I want to automatically when I hit the print button
that it enters 1,2,3 or 4 of 6 . Any ideas would be greatly appreciated

[Pepe Le Mokko]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.


Thanks you for helping us help you

[gweitzel81]

Hope this helps. I have it as an attachment. the tab that shows skid shipping label is the one I am having trouble with

[Glenn Kennedy]

Not much, to be honest!

Firstly, you asked for a formula (in the thread title), but posted in the VBA sub-forum. What do you want?

Secondly, you're familiar with this. I have no idea what I am looking at. What do you expect to see? Where do you expect to see it?

[gweitzel81]

So lets say i put 6 total skids when i prints out i get 6 pages but shows skid 1 2 or 3 of 6. My apologies if i put it in the wrong section. I had to shorten the file due to i had other tabs that made the file too big. Hope this helps.

[AliGW]

This thread has been moved to the formulas and functions section.