Select Case Statements

Please read forum rules - You must add the link to the cross post

So, it seems that i have a problem with this code. I am trying to get a information from one column to match it with another column to get me a result.

For example,

I have a Cake on Range("D5") and From Range("B5:B19") i have a cake that consist of 5 cakes. So i want to put that value 5 into Range("E5")

B5 Cake
B6 Cake
B7 Cake
B8 Cake
B9 Cake
B10 Muffin
B11 Muffin
B12 Bread
B13,B14..... etc

D5 Cake

E5 5

So, I am requesting how many Cakes are there from B5:B19, And D5 is the name # of Cake, So E5 i put 5

Please Login or Register  to view this content.

or can someone give me some one on one help at AIM- ladeda063610

If you want to count the number o items that code makes no sense at all. I would look at using a PivotTable.

Post the link to the other post as requested and don't ask for one to one help, this is a Public Forum if you bother to read the Rules you will see what I mean!

This user has had a temporary Ban at VBAX please do not reply to any further threads.
Thread Closed!