Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Filters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mab1963 - 24 Oct 2007 14:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.