Extract Rows based on Cell Value

[AndrewS6]

Hi

I'm wanting to extract rows from Data sheet into Report sheet based on criteria in cell B1 of Report sheet and column E of Data sheet.

eg. if Report sheet cell B1 = MLO I want to copy and paste all the Rows within Data sheet where column E contains MLO into the Report sheet (starting in cell C2)

Thanks
Andrew

[patel45]

Please Login or Register  to view this content.

[AndrewS6]

Thanks Patel

[Leith Ross]

Hello AndrewS6,

Welcome to the Forum!

I expanded what you asked for. Since B1's content is controlled by a validation drop down, the macro will fill the range starting at C2 with the row data. The macro is called automatically whenever B1 changes. This is accomplished by the Worksheet Change event for the Report worksheet. The macros are listed below. The attached workbook contains these changes.

Extract Rows Macro

Please Login or Register  to view this content.

Report Worksheet Change Event MAcro

Please Login or Register  to view this content.

[AndrewS6]

Thanks Leith. Just what I am after

[Leith Ross]

Hello AndrewS6,

You're welcome.