+ Reply to Thread
Results 1 to 5 of 5

FillDown only Filtered Active Cells

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Houston
    Posts
    17

    FillDown only Filtered Active Cells

    Hi All

    I need some help on following peace of code:
    HTML Code: 
    I have two columns, State and Country. First I filter only US in Country Column to assign Region based on State Location exp( Northern, Southern..etc). Now I need to filter Country column again to assign Region to rest of the country, but this time all country exept US.

    My problem in here is when I filter US or Non US country, it fills region for all cells not only filtered. I need assign region or fill cell with data only those cell that are filltered.

    Any thoughts on this issue would be greatly appricated.

    Izet

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: FillDown only Filtered Active Cells

    You're not making any reference to the visible autofilter range. I'm not going to try to replicate your data so here is a general example. If you want it tailored post a workbook.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-18-2008
    Location
    Houston
    Posts
    17

    Re: FillDown only Filtered Active Cells

    Hi, yeah I should upload files at first place. Here is a sample file, MasterProcessing file is where Macro code is, when it runs it will ask you to open second file.

    1. Filter US Country: It runs and assigns region to US States (Northern, Southern...etc) Region sheet is included.

    2. Filter Non US Country: It runs and assigns region to the rest of country based on table in Region sheet.

    Code assigns region to US states, then when filters again Non-US it overrides data that have been assign previously. Hope this will be helpful. I would like to adjust current code but if that is not possible than I'm open to integrate/modified code you provided as long it does filter and assign regions.

    Thanks a lot, I really appreciate your help on this issue.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: FillDown only Filtered Active Cells

    I've tidied up your code a little and tried to add your formulas. It's quite hard to follow what you're doing so I am quite sure the formulae are going in the wrong places and may refer to the wrong cells but the principle should be OK. If you can clarify the formula details I can adjust the code so it all works correctly.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-18-2008
    Location
    Houston
    Posts
    17

    Re: FillDown only Filtered Active Cells

    Wow, worked perfect, thank you....

    Good work, thanks a lot for your help and support an this issue. If there is no anything else, I would consider this issue as closed.

    One again, thanks a lot.
    Izet

+ 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