Hello,
I need a macro/VB Script that will search through calendars over multiple worksheets to see if the certain strings are found and return a message noting the number of occurences of those strings. Also, if an occurence is beyond the first occurence the following year, it will not count that first occurence but add the occurences beyond the first one plus that new occurrence.
For example,
Occurences:
January 14, 2008
June 17, 2008
August 1, 2008
December 24, 2008
Every occurence will output "Person X has 1, 2,.. 4 occurences".
Its now 2009.
Occurences:
January 12, 2009
Output "Person X has 5 occurences."
January 26, 2009
It outputs "Person X has 5 occurences."
Why? Because it is out of range of first occurence.
Lets say next one is August 22, 2009
Outputs "Person X has 4 occurences."
Why? It counts
December 24, 2008
January 12, 2009
January 26, 2009
August 22, 2009
Understand? Thanks in advance! :)
Configuration: Windows XP Internet Explorer 6.0
Copy a column if condition code excel vba Excel match multiple rows with one reference value - Excel vba 2007 find and replace date Excel vba chart seriescollection Excel vba compare column a in two worksheets Excel vba copy rang files Excel vba declaring one value to multiple variable Excel vba excel join multiple cells into one Excel vba find data worksheet multiple criteria autofilter Excel vba hide rows with multiple criteria Excel vba if multiple ranges are empty Excel vba populate formula Excel vba select column Excel vba sendmail reminder Excel vba values from multiple sheets Multiple filters in excel vba Multiple match function excel vba Using iserror in excel vba