Copy Data from Master Sheet based on Name & Date

[dsubash]

Dear All,

I have a database sheet (Daily Transaction) which contains details like name, date, location, sales, collections, dues etc for a specific month.
I need to copy all rows from the master sheet to another sheet (Report) with Name and Date as Criteria.

Attached is the sample file for reference. When the name and date is changed, i need all rows to be copied containing specific name and date without leaving any blank rows.

Tried working with FILTER / FILTERXML function but did not materialise. Is there any other option to pull such relevant data based on multiple criterias.

Thanks in advance.
Subash D

 

[AliGW]

In A18 and ENTER:

=CHOOSECOLS(FILTER('Daily Transaction'!A2:G301,('Daily Transaction'!C2:C301=C4)*('Daily Transaction'!G2:G301=F4)),1,7,2,3,4,5,6)

Will work in Excel 2024 or 365.

 

[Marc L]

Is there any other option to pull such relevant data based on multiple criterias.

With an advanced filter …​

​

 

[dsubash]

In A18 and ENTER:

=CHOOSECOLS(FILTER('Daily Transaction'!A2:G301,('Daily Transaction'!C2:C301=C4)*('Daily Transaction'!G2:G301=F4)),1,7,2,3,4,5,6)

Will work in Excel 2024 or 365.

Thanks, but i have an older version of Excel - Professional Plus 2019.
Any suggestions for 2019 Version.

 

[AliGW]

The attached uses PowerQuery (Get & Transform) to copy the table with the columns in the right order. I have then added two slicers to allow you to filter the data.