Quote Originally Posted by pjwhitfield View Post
what do the values in column B mean? are these stock amounts ie should MA01 get 16/93rds of the stock while MA04 gets 33/93rds?
These are the volumes that each Market Area should receive so yes, you're right. Sometimes the volume is 0 so would need the code to cope with that. The total volume should always match the number of stock units though.