Extract Data from List

[paulrh]

I have a simple inventory list as shown in table A1:D8. The user enters the quantity required in column E. I would like these chosen items to appear in a second set of tables according to the Category of the product.

The double criteria is confusing me (non-zero Qty and category). Any helpers?

Regards, Paul

Extract Data.png

[Glenn Kennedy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[paulrh]

Thanks. I have attached the workbook of the example shown.

Extract Data 2.png

Regards, Paul

[AlKey]

Please see attached file where you can find a suggested layout where you can use filter to see all categories or selected categories.

[FlameRetired]

In cell A3 of the Order sheet array-enter this formula.

Please Login or Register  to view this content.

in A10 and A17 these.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

The re-worked workbook is attached.

[paulrh]

Thanks for your great answer. Now I need to use it in my real spreadsheet

I am struggling to understand how this part of the formula works and am sure it is the reason I can not get it to work in my spreadsheet.

),rwCnt),ROWS($1:1)),COLUMNS($A:A)),"")

Thanks, Paul

[FlameRetired]

Thanks for your great answer. Now I need to use it in my real spreadsheet

I am struggling to understand how this part of the formula works and am sure it is the reason I can not get it to work in my spreadsheet.

),rwCnt),ROWS($1:1)),COLUMNS($A:A)),"")

Thanks, Paul

My apologies... my bad.....I used Name Manager for some ranges and forgot to find & replace with the ranges. The formula is

Please Login or Register  to view this content.

Still array-entered.

[paulrh]

Awesome - it works exactly as desired. I and the whole team thank you

[FlameRetired]

Glad it does the job. Thanks for the feedback.