Print Filled Cells Only

**seanyeap** · 07-20-2010, 06:48 AM

Hi All,
I have copied the vba coding from one of the threads. I humbly seek help to fine tune it. My intention is to filter and print the range where employees come in late. For instance, print all employees except Betty,Tim,Peter and Sean as they are never late. Do not print "No Name" row as they are no longer attached with the company. Attached herewith my file for better understanding. Any help and tips are greatly appreciated. Thanks in advance.

**TMS** · 07-20-2010, 08:38 AM

I think the easiest solution would be to add a column to count the occurences of "LATE" for each person and then filter on that as well as the name column.

Regards

**seanyeap** · 07-20-2010, 11:38 AM

Hi,
I am looking for a marco to accomplish the task, is it possible?

**seanyeap** · 07-20-2010, 09:49 PM

Hi All,
Can anyone help me out? Thanks in advance.

**JBeaucaire** · 07-21-2010, 07:51 AM

I would also recommend simply adding a "key column" on the right to flag the rows to display.

In N6 put the word "Key".
In N7 and copied down:
=COUNTA(D7:K7)>0

AutoFilter N6 for the word "TRUE" and print what's left visible, then turn off the autofilter.

You can record that into a very simple macro, yes? Give it a try.