Eliminating Blanks in a Summary Sheet
In a column to the right of your data area (eg column H) in your
Summary sheet, you can have a simple formula which reproduces the
values you have elsewhere, e.g.:
=D5
(in H5) if that is where your data starts. The formula can be copied
down. Then highlight column H and Data | Filter | Autofilter (check)
to apply a filter to cover column H only. Then in the filter pull-down
select Custom | does not equal | 0 (zero) to hide the unnecessary
rows.
Hope this helps.
Pete
On Jul 23, 2:42 pm, thaenn wrote:
I have created a worksheet that allows me to input various types of data,
which direct inputs the data to a Summary Sheet (separate tab). Is there a
way to have the Summary Sheet be more condensed by eliminating the blank
(empty) information from the Data sheet (not all of the data areas will be
filled in every time). Any help is appreciated!
Tom
|