Unfortunately user needs to decide which column should be included to the process as all workbooks come from different sources and they all have got a different data structure I am afraid that part can't be automated at all; but still good. I mean to be able to guide the user to highlight the ranges and run the data into the summary tab.That's perfect. If I learn how to do this I'll keep practicing on this. I know basics in VBA as had the online training and need to have more trainings..hopefully get there one day



Quote Originally Posted by sijpie View Post
No, that is easily doable.
On what criterium is the choice of column made? Can that be automated at all?