Skyman014j
New Member
- Joined
- Jul 28, 2017
- Messages
- 10
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 menu). Is there a formula for this? Or is a macro better suited? Any help would be greatly appreciated.
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 menu). Is there a formula for this? Or is a macro better suited? Any help would be greatly appreciated.