Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

2011-09-15 Thread Steve May
(learner) > > > On Tue, Sep 13, 2011 at 11:49 PM, Steve May wrote: > >> Dear Noorain, >> >> Thank you very much for your quick respose. >> I am attaching a modified file from excel-macros@googlegroups.com, with >> my request. >> Thank you once aga

Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

2011-09-13 Thread Steve May
gt; > On Tue, Sep 13, 2011 at 10:21 PM, Steve May wrote: > >> 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 Foot

$$Excel-Macros$$ Filtered Info must come into the Header or Footer

2011-09-13 Thread Steve May
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 mus