How to suppress an entire row in a table, if no data?
Q: how to suppress an entire row in a table, if the first row or column cell
is blank?
Background:
1) I am doing a mail merge will Excel 2007.
2) Excel data base: 100 clients each in a row with corresponding data
by year in each column.
3) Problem: I am sending a letter to each client with their data in a
table. Some clients have been with us for 10 years some have not, so the
first couple of rows in the table for some clients may be blank, how do it
suppress these rows?
|