All,
Required to work with an Excel and need a solution. Worked with formulas in the past but not sure if they will work for this.
I have 2 sheets and need to auto populate the second sheet with rows and columns from sheet 1 (A2:A100000 to D2:D100000) when column "H" is "Yes" (from a drop down...