+ Reply to Thread
Results 1 to 4 of 4

Apply 'X only to records that has Filters applied

  1. #1
    Forum Contributor
    Join Date
    09-01-2008
    Location
    Australia
    Posts
    108

    Apply 'X only to records that has Filters applied

    Hi All,
    I need to insert a letter 'X' in Column A when I press the Macro Button.

    The challenge is that I first need to do a filter first (Can be by cust No. Part No etc) and I only want 'X' to be applied to the records that has the filter applied.

    E.g
    I do a filter by cust No 228, and Part No ABC2. Then I only want 'X' to be applied to these records.



    How do I go about doing it? Any help is appreciated!

    Thanks and Regards,
    Nironto
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Apply 'X only to records that has Filters applied

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-01-2008
    Location
    Australia
    Posts
    108

    Re: Apply 'X only to records that has Filters applied

    Thanks John for all your help!
    Made my day!

    Regards,
    Nironto

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Apply 'X only to records that has Filters applied

    You're welcome. Glad to help out, and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1