Posts by andyjw

  • Show filter value in a cell

    Hi All


    I need to show the value of the filter selection choosen from the drop down list (certerial) in a cell at the end of a column being filtered.


    Is this achieveable in excel 2003


    Andy

  • Reset Auto Filter

    Hi


    Active sheet has Auto filter on. various filters can be selected to drill down to required info,
    Is there a quick way to reset all filters back to ALL in the current sheet and optional all sheets. I do not want to remove filters from sheets.


    Can u help


    Regards


    Andy