Sort:  

there is no need for VBA with excel power tools. They are a vba killer and way more powerful. You such look up M language and power query. I will post some stuff and this when i return for my holidays