Looping through data on consecutive pages
I am hoping to create a WorkBook of 20-30 WorkSheets. Each sheet would
include a 5 column x 8 row table of various dates. I would like for a macro
to cycle through each of the sheets, looking for a user-defined month (eg,
June) within the table and, if found, print that WorkSheet, then skip to the
next WorkSheet. If not found, it would simply go to the next Worksheet and
search for the month on that sheet.
I need help with setting up the looping procedure that looks for the date
and then prints or continues on. Can anyone offer guidance? Thanks in advance.
--
- markvi
|