I have a large spreadsheet with several thousand rows of data. I need to break this data into subsets, first by location and then by weights which sum or total around 2000 tons each. It doesn't matter if there is one row or dozens that are put into a 2000 ton group together. The rows will not be consecutive.
Currently, I filter by location and then summing by dragging the cursor until it is close to 2000 tons and then I do the math and then search for a row with approximately the correct weight. I can have a variation of up to 1%.
Any suggestions on how to improve this tedious process? Thank you.