VBA copy sheet 1 to Array and put relevant information on sheet 2

[Peteor]

Hello! I have a worksheet where Columns A:Z are used. I would like to take all rows on sheet 1 where Column E has a value of "2" AND Column J has a value of "Example", and copy the information from the Entire Row to sheet 2. Row 1 on sheet 1 is just header information. I would also like this on sheet 2.

I recognize this to be a very broad question, and believe this to be done with "CreateObject("scripting.dictionary")"... I would like to understand how to use this class on my own, but am struggling. Any comments would be greatly appreciated...

 

[Peteor]

Not a question, JUST informational for the next user. If you ever find yourself doing this, I have found an issue if the source cells have formulas (VLOOKUP()s to another sheet for instance). Users tend to use the following to speed up their macros:

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.EnableEvents = False


'Do Stuff

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True

Make sure you re-enable these BEFORE .AutoFilter.Range.Copy Sheets("sheet2").Range("A1"). If you do not, it will copy the values before the values update, which will be incorrect.