ajrob
05-14-2007, 04:27 PM
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
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