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
Bookmarks