Hi, I have a File with no. of rows that change everyday, In file, I have data until column z, columnX is decision column which contains 4 values" Venice, Paris, Newyork and Italy" I need a macro to extract 27 rows to a new sheet named verification based on 2 scenarios
1, If Venice and Paris is less than 27,
then extract all Venice and Paris rows and the remaining rows can be random of Newyork and Italy.
2, If venice and Paris is equal to or greater than 27,
Then extract 90% of All venice and paris and remaining 10% can be random of Newyork and Italy.
I hope You can help me with this , Thank you In advance
1, If Venice and Paris is less than 27,
then extract all Venice and Paris rows and the remaining rows can be random of Newyork and Italy.
2, If venice and Paris is equal to or greater than 27,
Then extract 90% of All venice and paris and remaining 10% can be random of Newyork and Italy.
I hope You can help me with this , Thank you In advance
