Copy only filtered data on each cell and paste on specific cell in another sheet

Hi Guys,

I have been struggling with copying data from filtered table and paste to specific cell in another sheet.
It would be so great to have code in loop because the data can be up to thousand records.

I have below table in main sheet:

Name ID Address Phone
A 1111 12 Yellow Street, CT 20115 9985522
B 1112 13 Blue Street, CT 20115 7485522
C 1113 22 Red Street, CT 20115 3255822
D 1114 74 WhiteStreet, CT 20115 1255522


Then I would like to copy filtered data from above to paste in specific cell in this sheet2

A1 B1 C1 D1
Name: A ID: 1111
Salary: 12,000

Name: B ID: 1112
Salary: 13,000

and run down until the filtered data in main sheet finish.

Is this possible?

BUMB!

Please I really need help T_T

Try this:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Originally Posted by ikboy

Try this:

Please Login or Register  to view this content.

Hi
Thank you so much Ikboy.
I tried the code but it copied every row to paste in another book.
Can you please adjust the code to copy only the filtered row?

Try this:

Please Login or Register  to view this content.

Originally Posted by ikboy

Try this:

Please Login or Register  to view this content.

Hi Ikboy,

That's a magic. Thank you so much