Dear Friend, I have table with many columns. If one of them is gender and it contains either 'Boy' or 'Girl'. 1. If I filter only 'Boy' then the Header or Footer must have "Boy" in it.
2. Further before printing excel must ask what should be there in the header or footer. 3. Automatically it must add a word or words related to the filtered word. eg. If I filter 'Boy' then can it have a "Boys Only" Thanking you in Advance. Bye for now Steve -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
