Copy number criteria from Master to multiples sheets

[marreco]

Hi.

I try a way to copy data in a big sheet, but I'm stuck.

I need get data based criteria in column T from Master sheet and paste in 5 differents sheets.

My Sheets
1 - Master (200 thausand rows, 56 columns), criteria in column T
2 - Entry_Data -> (Paste here all data based criteria which start 1* and 2*, in column T) e.g 1102, 2353 etc
3 - CFOP_5403 -> (Paste here all data based criteria 5403 in column T)
4 - CFOP_5102 -> (Paste here all data based criteria 5102 in column T)
5 - Out_Data -> (Paste here all data based criteria If not 5403, 5102 and not start 1* and 2*, in column T)

Cross-post
https://www.mrexcel.com/forum/excel-...es-sheets.html

I try some like this code below, but it will be big and I need think how to do another criterias.

Please Login or Register  to view this content.

Thank you!

[marreco]

Hi.
I made a progress, but the last part is not work.

Any idea to solve this?

Please Login or Register  to view this content.

[marreco]

Hi, someone can help me?

[Marc L]

Hi,

restart from the yellow banner at the top of this page …