Hi
I am trying to workout how to create a specific summary of a table of sales information that is on a separate worksheet of a workbook. It's probably quite simple but I haven't been able to work it out yet!
For example the Data Table (Worksheet) might look like this:
The Summary Table has a Drop List to select the sales product from the Data sales. Selecting the product will return a sales list that includes all dates with sales figures in it. A sales date that does not have any sales figure entered against it should not be included in the summary table.
The Summary Table (worksheet) would look like this:
I don't know if a Pivot Table will work? And I haven't been able to workout a suitable "Filter" or XLookup" formula etc. So I am a bit lost now on how to create the Summary Table.
Is there an expert that can kindly guide me!
I am trying to workout how to create a specific summary of a table of sales information that is on a separate worksheet of a workbook. It's probably quite simple but I haven't been able to work it out yet!
For example the Data Table (Worksheet) might look like this:
The Summary Table has a Drop List to select the sales product from the Data sales. Selecting the product will return a sales list that includes all dates with sales figures in it. A sales date that does not have any sales figure entered against it should not be included in the summary table.
The Summary Table (worksheet) would look like this:
I don't know if a Pivot Table will work? And I haven't been able to workout a suitable "Filter" or XLookup" formula etc. So I am a bit lost now on how to create the Summary Table.
Is there an expert that can kindly guide me!
