Hi all,

seeking help on autofilter and to get 10% data of Total visible data and copy paste it to sheet name 10%
And to autofilter the data and to get 50% data of total visible data and copy paste it to sheet name 50%

Below is example data,

Name Status %
Rag Completed 10%
Rag pending 10%
Rag Completed 10%
Rag pending 10%
Rag Completed 10%
Rag pending 10%
Rag Completed 10%
Rag Completed 10%
Rag Completed 10%
Man pending 50%
Man pending 50%
Man Completed 50%
Man pending 50%
Man Completed 50%
Man pending 50%
Man Completed 50%

what i want is

Autofilter third column "10%" and autofilter status only "completed"
so now, autofiltered visible data......

Now what i want is , out of total visible data. I want only 10% of this Total visible data to copy and paste in to sheet named 10%.

like wise to do for 50%.

code to apply autofilter third column "50%" and to autofilter status "completed"

now i want 50% data of total visible data to copy pasted in sheet named 50%.

That is all i want.........please help me with some example workbooks.