Copy rows into 3 different sheets based on specific criteria, using VBA

[macevedos]

Hello everyone,

I have the following document, the information to copy is located in the sheet called "Source", where I want to copy the entire row into 4 different sheets, using VBA.

The columns that will be used as a condition are C, D, E, and F.

If Column C has the "TT" then, the entire row should be copied to the sheet "Tiny"
If Column D has the "Y7-10" then, the entire row should be copied to the sheet "7-10"
If Column E has the "Y11-13" then, the entire row should be copied to the sheet "11-13"
If Column F has the "Teens" then, the entire row should be copied to the sheet "Teen"

I'll appreciate your support on this matter, I've been trying several ways but obviously, I'm not so good.

Thank you!

 

[Joe4]

Welcome to the Board!

Instead of using VBA, this can be done really easily using the new Excel filter function.
All you need is one formula on each sheet, with your desired condition, and all the results will "spill" into that sheet.
See: FILTER function - Microsoft Support

 

[macevedos]

Hello Joe4,

You are totally right, I just watched the video and it's much simpler in this way.

Thank you!

 

[Joe4]

You are welcome!
Glad I was able to help.

Yes, that new FILTER function is a great new addition, and makes things a lot easier.
It is one my my favorite new functions to come around in a while!