Hi,
I think I've been looking at this for too long now and can't find my way forwards with it so any help is gratefully received.
I have 4 licence types with a value representing the sales of each type and I need to assign those sales units to various price bands, of which I have three. The first 450 licences should go into Band A, the next 9550 licences should go into Band B and anything remaining should be assigned to Band C.
In addition to this, I need to assign the licences to bands in order of licence type priority i.e cheapest (Band A) first.
I'm trying to avoid VBA where possible but I'm pretty sure it doesn't need it, there's something very simple that I'm just not seeing.
I've attached a mock up of what I'm looking at and hopefully that will help me better articulate what I'm trying to achieve.
Thanks in advance.
Bookmarks