J
John F
Excel 2003:
This one is likely so simple, I didn't dare post to programming.
I need this now, to keep boss happy - Else I would spend more
study time on it. Sorry.
Note:
If possible, macro to work back to 1997 Excel version.
Sorting to group condition not an option.
Question:
If cell B? = *, then check next row.
If cell B? is blank, then hide row, then check next row.
If cell B? = **, then hide that and stop macro.
( the ** indicates 1st row below any required data)
Please advise if there is a better way to end the macro.
The nice part about using something like **, is that it
gives me a clear visual of situation.
Thanks in advance.
This one is likely so simple, I didn't dare post to programming.
I need this now, to keep boss happy - Else I would spend more
study time on it. Sorry.
Note:
If possible, macro to work back to 1997 Excel version.
Sorting to group condition not an option.
Question:
If cell B? = *, then check next row.
If cell B? is blank, then hide row, then check next row.
If cell B? = **, then hide that and stop macro.
( the ** indicates 1st row below any required data)
Please advise if there is a better way to end the macro.
The nice part about using something like **, is that it
gives me a clear visual of situation.
Thanks in advance.