|Subject:||Counting Highlighted Cells- Fastest way?|
|Date:||Mon, 28 Jul 2008|
Currently I am working on web reports in which I have highlighted
cells in several different worksheets.
I then have a summary page which counts the Sum of Column J,
COUNTA(J2:J1000) which counts the number of data entries in the range,
and then i have to manually filter column J by highlighted
color(yellow). Not all rows have a highlighted column and so I
currently just Filter by Cell Color and is the Count function at the
bottom of the screen; however this is time consuming and I am trying
to automate this report as much as I can, but I am stuck on this.
I am using Excel 2007 and have some experience with VBA, but cannot
seem to come up with a way to automatically count(through function or
macro) populate my summary page.
If anyone has any suggestions or ideas, I would greatly appreciate it.