Hi All,

I'm looking to transfer over rows of data based on one criteria. I have used an array formula but, after reading some threads, it looks as though VBA would be a better. To explain:-

I need to transfer over the data from columns indicated by 'a' , 'b', & 'length' if the 'dia' (the criteria) matches.

screen1.PNG

I need it to transfer over to the below table on a different tab within the same worksheet.

screen2.PNG

There is multiple criteria (dia's) i.e. 100dia, 150dia, 225dia etc. etc. All have there only table ready to receive information if the criteria is met. There will be potential thousands of rows of data and at the moment i'm having to go throuhg and copy / paste where necessary - believe a VBA may save a bit of time.

Any help on this would be greatly appreciated.