VBA - Copy rows containing specific data in to new worksheet if criteria met.

[JamesRobbins]

Hi all,

I'm new to VBA and struggling to find anything online which can help or works.

I have a sheet of data and looking to find a VBA which looks at Column M for 'Crew Training Instructor' and if found copies all data in that row in to a new worksheet called "CTI"

Can anyone help or advise?

Thanks

James

 

[Joe4]

Welcome to the Board!

I don't think you need VBA for this at all, thanks to the new Excel FILTER function.
See here: FILTER function - Microsoft Support

I think this should be pretty easy to do with one simple formula.