Pull all row data based off another cell value

[lbradbury1013]

Hello,
I'm looking for a way to pull all row data from another sheet based off a cell value. I have an open sales order list that I want to extract all lines related to a single customer. But this is pulling from another sheet.

Here is an example of the data sheet:

Customer Name	PO Number	Line	Release	Part	Selling Qty	Ship By	Total Shipped
Customer 1	123456	1	1	AMMPART	10	10/31/2022	0
Customer 1	123457	1	1	ABBPART	15	10/28/2022	0
Customer 1	123458	1	1	ACCPART	25	10/15/2022	0
Customer 1	123458	1	2	ACCPART	10	10/25/2022	0
Customer 2	98745	1	1	BCCPART	150	11/25/2022	0
Customer 2	98745	1	2	BCCPART	150	12/25/2022	0
Customer 2	65412	1	1	BMMPART	10	10/15/2022	0

I want to have another sheet that has headers for table listing the customer name in the example above it would be Customer 1, and pull all the row information based off cell value of the header "Customer 1"


I hope that makes sense.

 

[Joe4]

You should be able to use the FILTER function to do this pretty easily.
See: FILTER function

 

[lbradbury1013]

And

You should be able to use the FILTER function to do this pretty easily.
See: FILTER function

This would pull the row information into another sheet?

 

[Joe4]

And

This would pull the row information into another sheet?

Yes, you just place the the formula in the first cell wherever you want the results returned to, and the additional columsn/rows will automatically "spill" down/across.

So if you were returning the results to Sheet2 and pulling data from Sheet1, then you might have a formula like this in cell A2 on Sheet2:

=FILTER(Sheet1!A2:H8,Sheet1!A2:A8="Customer 1")

Try it and see!

 

[lbradbury1013]

Yes, you just place the the formula in the first cell wherever you want the results returned to, and the additional columsn/rows will automatically "spill" down/across.

So if you were returning the results to Sheet2 and pulling data from Sheet1, then you might have a formula like this in cell A2 on Sheet2:

=FILTER(Sheet1!A2:H8,Sheet1!A2:A8="Customer 1")

Try it and see!

AMAZING! I didn't realize it would pull into another sheet!

 

[Joe4]

AMAZING! I didn't realize it would pull into another sheet!

You are welcome.
Most Excel formulas will, as long as you include the Sheet name reference before the Range reference.