how to summarize data coming from two worksheets

[rodelrengel]

hi all!
need help in summarizing data coming from two worksheets. attached are the the 2 files for your perusal.
thanks..

[Glenn Kennedy]

What do you expect to see?

Where do you expect to see it?

Are your real data in different worksheets in the same workbook (file) or in different workBOOKS (2 separate files)?

[rodelrengel]

i want to know the formula in summarizing the data in a different workbook. that is, the summary of specific persons with their corresponding "dates", "cars bought" and "details' for year 2020 & 2021. thanks.

[JeteMc]

I feel that the easiest way to do this is to put everything in one workbook, combine the tables of data for 2020:2021 and let a pivot table do the work of displaying the result.
If there are actually many sets of data then you may be able to use Power Query to append the tables one to another.
The pivot table should have date (ungrouped), Cars bought and details in the Rows area.
The subtotals and grand totals should be turned off and use the Tabular layout.
Note that the names may be changed using the drop down in cell D5 on the PT sheet.
Let us know if you have any questions.

[rodelrengel]

hi JeteMc, thanks for spending your time answering to my query. i might use pivot table to summarize the data. kudos also to all excel gurus out there! cheers1

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.