Hello all, I have a spreadsheet listling multiple products I am testing.
Each product may have multiple steps (rows). At the top of each product, I
have the owners name in a owners name column. I want to be able to filter by
owner, so I only show one owners product at a time. Problem is, for the
owners column, I only put their name once, which is at the top of each
section containing that product. So when I filter, and select that owner, the
blank rows, won't show up..How do I filter so the blank rows show up too?
Thanks
Mark
Max - 24 Oct 2007 14:56 GMT
Try Debra Dalgleish's page for ways to fill in the col blanks:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells
Fill Blank Cells
Fill Blank Cells Programmatically
(Sub FillColBlanks() by Dave Peterson)
With the blanks filled from above, you can then autofilter as required

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Hello all, I have a spreadsheet listling multiple products I am testing.
> Each product may have multiple steps (rows). At the top of each product, I
[quoted text clipped - 5 lines]
> Thanks
> Mark