Hi all
I am attempting to extract data from a large table into a smaller table depending on a couple of criteria (referencing other cells)
I have a report date (cell B1) and a hold type (cell J1). My raw data table is in a seperate tab named 'data' with the columns as below:
What I am aiming to do is to have a new table in my summary sheet which pulls ALL results from the raw data table as long as the report date in B1 matches the report date in column V of the raw data, and the hold type in J1 matches the hold type in column U (wait reason). The amount of returned rows will vary so I am struggling a little with how to ensure that all are included.
I hope that makes sense.......
Happy to provide more information if required
I am attempting to extract data from a large table into a smaller table depending on a couple of criteria (referencing other cells)
I have a report date (cell B1) and a hold type (cell J1). My raw data table is in a seperate tab named 'data' with the columns as below:
Event No | Cust | EG | EP | OT | Event Desc | WH | Order Date | Req Date | Est Desp | PO Worst Case | # | St | Value | Alloc Value | Alloc% | OS Invoice | #No PO | B2B | Hold | Wait Reason | Report Date | Previous Report Date | Lookup ref1 | Lookup ref2 | Previous Report Wait Reason | PO Status Value |
What I am aiming to do is to have a new table in my summary sheet which pulls ALL results from the raw data table as long as the report date in B1 matches the report date in column V of the raw data, and the hold type in J1 matches the hold type in column U (wait reason). The amount of returned rows will vary so I am struggling a little with how to ensure that all are included.
I hope that makes sense.......
Happy to provide more information if required