Good afternoon,

I'm looking to seperate inventory items into PRIME and SUB units..

Example: Sodas have are in cases of 24 so the PRIME unit would be 1. If you had 26 cans total it would then be 1 PRIME(cases) and 2 SUB(cans). I need the prime and sub units in seperate cells.

Hope i explained what i needed so you understand..

Thanks

Geoff