VBA Question-

[ljg713]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Fruit[/TD]
[TD]ID[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2[/TD]
[TD]1-15-2000[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]3[/TD]
[TD]2-29-2011[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]6[/TD]
[TD]3-6-2007[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]5[/TD]
[TD]6-5-2010[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2[/TD]
[TD]8-21-2015[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]1[/TD]
[TD]9-4-2014[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]3[/TD]
[TD]6-18-2015[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]5[/TD]
[TD]2-19-2002[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]4[/TD]
[TD]7-3-2009[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]6[/TD]
[TD]1-20-2005[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]7[/TD]
[TD]2-3-2010[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]6[/TD]
[TD]5-27-2006[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]2[/TD]
[TD]4-21-2009[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]8[/TD]
[TD]5-20-2004[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]2[/TD]
[TD]6-2-2009[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]9[/TD]
[TD]5-20-2001[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]3[/TD]
[TD]4-19-2000[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]7[/TD]
[TD]3-18-2013[/TD]
[/TR]
</tbody>[/TABLE]


Hello,

I am new to VBA and have been trying to find some code online similar to the problem I am trying to solve. The table above is similar to the data I am using. I am trying to find the number of items in the 'fruit' column by month and year. The second column of id's is irrelevant.

Basically, I would be trying to take the data from the table above to fill out the table below so that each fruit would be in one row counted and sorted by dates based off of month and year from January 2000 though December 2015. Any ideas/tips? Thanks

[TABLE="width: 500"]
<tbody>[TR]
[TD]Fruit[/TD]
[TD]Jan-2000[/TD]
[TD]Feb-2000[/TD]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nov-2015[/TD]
[TD]Dec-2015[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

What you are really looking for is to get a count of records that fall between the first and last day of each month.
You should be able to use the COUNTIFS function to get these.
See: Count the number of Excel records that fall between two dates - TechRepublic