extracting rows of data from on sheet to another based on Column A

[sdehod]

Hello,

Here is my Issue I have a workbook that has a bunch of sheet. On the last sheet I need to break down info based on the first sheet. I need it extract all the info for certain division. All divisions are listed in column A but I need all in the info from the falling row A,B,C,G,H,I & J that corresponded with the certain division.

I want to be able to type the Division "LRM" and have all the info (row A,B,C,G,H,I & J) that start with LRM to be Transferred to separate sheet. I have attached the workbook I am using. It contains a bunch of different codes and sheet. I am just so confused!

[sdehod]

Pivot table works Awesome ! Figure it out!

[playaller]

Hello,

Glad you made use of the pivot tables. If you still want your original solution then please see the attached file. Go the Sheet 2 and click the button to bring up the form.