Results 1 to 3 of 3

Thread: EXCEL help

  1. #1
    Join Date
    Jul 2003
    Posts
    34

    Unanswered: EXCEL help

    I have autofilter setup where I can select different fields.
    When I switch from one value to another in the autofilter, all the other cells in the sheet should be cleared..which enables me to enter the values corresponding to that field. I am using Excel 2000.
    Any help appreciated

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Hi,

    Are You using VBA? If so can You provide the board with the code?

    Kind regards,
    Dennis
    Kind regards,
    Dennis

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091

    Re: EXCEL help

    Originally posted by asram
    I have autofilter setup where I can select different fields.
    When I switch from one value to another in the autofilter, all the other cells in the sheet should be cleared..which enables me to enter the values corresponding to that field. I am using Excel 2000.
    Any help appreciated
    As with Dennis, I'm not clear what you mean.

    If not VBA, then I wonder whether you need to undo the first filter to restore all, before you move onto the next filter.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •