2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Separate table in pages but smartly

Hello everyone.

I work in logistics and I'm required to check merchandise received against the ordered amounts.

Currently, this is done by checking against a printed version of a table with all suppliers and quantities. The lines are ordered by supplier name. The print is about two to three pages long.

Merchandise comes to the warehouse in five separate trucks, so I would like to simplify the processes by grouping suppliers by truck. So all the first delivery, then the second, etc. Still ordered alphabetically within a group.

What I would like help with is to know how, if possible, to print the table separated in a way that truck groups are kept on the same page if possible. Like having the first two trucks on the first page, next two on the second, last on the third.

I would like this to be flexible, because not all suppliers are ordered from every day. Maybe the last truck has only three entries, and it wouldn't make sense to have it apart. Or maybe the first truck will be stacked and needs its own page.

Thank you for your consideration.

submitted by /u/QuandImposteurEstSus
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#logistics
#merchandise
#suppliers
#quantities
#warehouse
#trucks
#delivery
#table
#grouping
#ordering
#flexibility
#printed version
#alphabetically
#entries