Attached is a file i am working on, i am still having a few issues with codes - i have researched a fair bit and gotten as far as i have. I have included the problems i am having in the first Tab.

If someone can have a look and point me in the right direction please.

Packs Calc.xlsm