Creating Palette Labels at work
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.
|