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
Bookmarks