Copy multiple rows depending on value of cell.

[Closed]
Report
-
Hello,

I'm working on a excel-book where it is 3 sheets of data. In the 3rd sheet I want to be able to type in e.g. Ior and then get all the rows from sheet1 and 2 to be collected in the 3rd sheet. The value to look for is always in F:F and the sheets are 10 columns wide (J) and sheet1 is 154 rows and sheet2 236 rows. How should i make that happen?

Best Regards
de SAØASG
Oscar Andersson