Creating Summary Sheet on Unique items (multiple columns) using VBA

i have a workbook with a lot of data that i wish to summarize so that i can use it else were as a summary sheet. How to do get a summary automatically calculated on unique items only

i have attached a test workbook for your help

The detail sheet is the details and then the summary sheet is the result i would like to get automatically not using any formula.

Try the attached

Please Login or Register  to view this content.

if i need to add additional columns what areas should i look at to modify. So far it works great no i am trying to incorporate it into a bigger file I modifiy everything to work ok however the summary is not pulling in.

What do you mean by "add additional columns"?

for example if i want to expand the array what areas i need to modify to do so. I understood the column to change the date and what to return however i am having an issue with the summary area jan-dec. everything else is working where i modify it except that area.

It's fully depends on your sheet layouts, due to the difference between data sheet and the summary sheet.

The summary sheet has less columns. So need to see Exact sheet layouts.

Please find extract with additional columns. Thank you so much for your help

TESTING3.zip

try

Please Login or Register  to view this content.

Thank you for the code, the sumCol seemst to be looping from v to the end of the columns. Also instead of adding a sheet can this run as an update to a defined sheet, select sheet, clearcontents and update?

Thanks again i really do like the array concept it runs pretty quickly and does to grow my workbook.

Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.