Macro or Formula? Sorry for my lack of knowledge, in over my head and need help.

[Skyman014j]

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.

 

[Skyman014j]

This worked! Thank you so much. I am genuinely interested in learning more about VBA and formulas. Any recommendations on starting points for learning (books, courses online, etc.)? I'd love to be self sufficient enough to be able to do exactly what you did on my own. Thank you again for your help.

 

[NoSparks]

Any recommendations on starting points for learning (books, courses online, etc.)?

member hiker95 has a thread somewhere here with quite an extensive list that pertains to just that question.
I don't have a link to it but searching the forum should bring up something.

 

[Skyman014j]

Great, thank you!