Hi all, maybe someone can work this out I have a sheet as below
I need a bit of sorting when user puts in how many in A1, code CBO in
A4, I want the numbers to go into the appropriate columns 10 goes into
A8.. 10 goes into A9 and so on.

I have a another sheet that has all the codes listed. How do I manage
to have those numbers appear in the appropriate cells???

A1 A4 A7 A8 A9

10 CBO 10

10 KD
10

5 CB
5

4 CBO 4

2
KD 2

3 IB 3


Thanks so much
Regards
Stephen