VBA transferring rows of data based on one criterion

[JSilkstone]

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.

[BadlySpelledBuoy]

Hi and welcome

Any chance you could attach a sample workbook? Easier to work with those than pictures.
Might be worth showing a couple of examples of your expected output too.

BSB

[JSilkstone]

Thank you!

I've attached a sample workbook. I'm looking to transfer over the data on the 'csv' tab onto the 'runs' tab. The criteria being the diameter in column 'A' on both.

I've included an example output tab for further clarity.

JS