Automatic numbering till a threshold is met and then start with the following number.

Hello everybody,

I'm breaking my head over this problem for a couple of days now.
Maybe somebody knows how to get to the desired point.

I've got an excel file with in Column X weights of parcels.
I need to generate the same number in Column A untill the threshold of 1100 Kg is met.

So for example;
Excel needs the generate number "1" from row 2 till 28 because then 1100 kg is reached.
After that it needs to do the same with the others parcels only with number "2", "3" etc.

I've allready added a macro with automatic sorting. So the parcels are already in the right place.

Hopefully somebody is able to help me with this problem.

Try

Please Login or Register  to view this content.

Thank you!
It seems to do something, but i'll have a look tomorrow morning.
As far as my knowledge goes for macro's.