Creating Palette Labels at work

[boorman]

Hello, I am currently trying to create either a forumla or macro that wil
create a palette count within excel. Each Palette holds a max of 60 boxes

The database has a row for each box in it but the final pallet has a variabl
amount of boxes on it

I need the result to count in increments of 60 unless there is a blank row i
the database. ie, 60 "1", 60 "2", 60 "3", 4
"4"

I hope this makes sence.

 

[CellShocked]

Hello, I am currently trying to create either a forumla or macro that will
create a palette count within excel. Each Palette holds a max of 60 boxes.

The database has a row for each box in it but the final pallet has a variable
amount of boxes on it.

I need the result to count in increments of 60 unless there is a blank row in
the database. ie, 60 "1", 60 "2", 60 "3", 45
"4".

I hope this makes sence.

Declare for us what a finished palette label should state, as in:

palette 1 60 Pcs or

Pallette 1 of 60

or WHAT?

What increments? The palette number, or the piece count?

Does each palette represent variable piece counts?

 

[boorman]

CellShocked wrote on 01/22/2012 15:48 ET

On Fri, 20 Jan 2012 07:12:19 -0600, boorma
wrote

Declare for us what a finished palette label should state, as in

palette 1 60 Pcs o

Pallette 1 of 6

or WHAT

What increments? The palette number, or the piece count

Does each palette represent variable piece counts

HI and thank you for taking the time to reply to me

THe labels need to read Palett 1 of 12, 2 of 12, 3 of 12. THey need to go u
b
1 when 60 rows of data are matched. a blank row has been inserted into the D
between Stock types so the forumal/macro would need to stop a nd restart a
eac
blank row

I hope this helps.