+ Reply to Thread
Results 1 to 5 of 5

Add an extra criteria to a filtering Macro

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    Hamburg, Germany
    MS-Off Ver
    2016
    Posts
    44

    Add an extra criteria to a filtering Macro

    Hello Excel Experts,

    It is me again bothering with my solar Panels Project.

    What the current VBA macro I have does is, searching for the Location of cells that have a value smaller as the value in the column "25%Average" and posting this Location on a new sheet.
    However I would like to add a new criteria which will always be a column after the "25% Average" column, this criteria will be Watt Output Value.

    What I would like to know is, how can I add an extra criteria, so the macro will search and post the Location of the values that are smaller than the 25% Average but only when the Output value from is greater than "100"?

    Thank you in advance, attached is the sheet with info and Code, I just posted ir for 5 Panels but the actual sheet has over 2500.

    Jorge
    Attached Files Attached Files
    Last edited by jorgeflores; 11-07-2017 at 11:03 AM. Reason: Problem Solved

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Add an extra criteria to a filtering Macro

    Please Login or Register  to view this content.
    And you have no matched data from you data provided.

  3. #3
    Registered User
    Join Date
    03-16-2017
    Location
    Hamburg, Germany
    MS-Off Ver
    2016
    Posts
    44

    Re: Add an extra criteria to a filtering Macro

    Thank you jindon.

    You mean that there are no results matching the criterias, from what I sent? I don´t get it.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Add an extra criteria to a filtering Macro

    That's correct.

    No data which is smaller than 25% Average when Watt Output is greater than 100.

  5. #5
    Registered User
    Join Date
    03-16-2017
    Location
    Hamburg, Germany
    MS-Off Ver
    2016
    Posts
    44

    Re: Add an extra criteria to a filtering Macro

    Yes, I also saw that, but I was not sure I got what you were saying it.
    It worked perfectly, thank you very much again for your help so far, I will try to go on.

    Jorge

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to set extra extra thick outer border for selected column and row:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2014, 01:43 PM
  2. Please help to find a Macro to for filtering and sorting based on two criteria
    By 1Melina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2013, 12:54 PM
  3. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  4. Extra row after filtering
    By pbateman56 in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 05:05 PM
  5. extra criteria in autofilter macro
    By Robotacha2010 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-24-2010, 11:58 AM
  6. Applying extra criteria when using macro to password protect sheets
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2007, 11:03 AM
  7. [SOLVED] trouble filtering a list. Why isn't column filtering?-number of criteria
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2005, 11:05 AM

Tags for this Thread

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