Excel 2007 VBA Macro on command button

[lengwer]

Hello,

I am trying to sum the value of cells in column P on Click through command button. I have created the command button but the kicker is the values within the column could be A-Z. I need the value to be listed out in totals below the EOF line. The Macro will end the sum at EOF in Column A.

Column P Column A
09/04/13 E
09/04/13 F
09/04/13 E
09/03/13 D
09/04/13 E
EOF

The letters at the end of the date are to be counted.

Descending in Cells however IF there is no A or B or R or S then these cells need to be absent. The good thing is they will always be in order (i.e. if there is an I and a C then you will have A-I that will exist as data but it is always changing.

D = 1
E = 3
F = 1


To Total all rows (which may have new rows added so it is to end at EOF in Column A) I do not have enough code worked up on this to give an example yet but once I have enough written I will submit. If you have and suggestions in the mean time please share.

Thank you,
Leslye

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[lengwer]

Please see attached sample workbook.