Consolidated Messages/Strings

[ajrob]

I've got an application with a several "standard responses" (or text strings) that are triggered by conditions within a worksheet. One approach is to write each "standard response" in a cell that's triggered by an if/then condition. The problem with this is that you end up with a lot of blanks in between text for those conditions that are not true.

Are you familiar with a way to consolidate blank rows, or better, to write non-blank rows to a new tab in Excel?

See attached.

Thanks in advance for help/advice.

Adam

[Bob Phillips]

You want to copy the data from Alerts to another sheet? Any particular sheet?

[ajrob]

I was thinking of one of two approaches:
a) a macro that would contain the conditions, and write only the "Alerts" with true conditions to a new tab called "Alerts".
b) keep all the conditional logic in the tab called "Alerts", and copying the non-blank (or rows where condition = true) to a new sheet ... it could be called anything ... Alerts2

[Bob Phillips]

.

[ajrob]

Any ideas on the other approach ... a macro that would perform the decision logic an write the "standard responses" to a new worksheet??

[Bob Phillips]

Why, doesn't that work?