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.