View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pano pano is offline
external usenet poster
 
Posts: 84
Default Sorting Cells on letters and numbers and placing result in one of 3 columns

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