Copy by Transpose the Filtered Result

[chasoe]

Dear Sirs,

I've a problem which I guess should better to solved by using VBA (instead of Excel functions).

1. I've 2 worksheets, Sheet2 contains a 2-column table which I wish to filter
2. The filtering criteria will be in Sheet1 column A

My idea is to write codes to base on Sheet1 column A values as filter criteria in Sheet2 (column A), with the filtered result copied by transposing the value to Sheet1 column B.
That is the filtered result (vertically) to be copied to Sheet1 column B and/or after horizontally.

The codes can loop through all the Sheet1 column A values one by one.

I've drafted by codes, but seems too many errors to debug.

Appreciate if someone could help.

Many thanks.

[jindon]

Try

Please Login or Register  to view this content.

[chasoe]

I've tested the codes and they work miraculously fast.
These codes are too advanced to understand and I need to take sometime to digest so that I may modify them to suit exact cell references in my true case.

Very grateful for you help !

[jindon]

If you feel better Filter/Copy then

Please Login or Register  to view this content.

[chasoe]

I've tested your second set of codes, the codes can finish to the end but with incorrect result possibly due to mis-positioning in cell reference.

[jindon]

OOps, missed bold part...
should be

Please Login or Register  to view this content.

And please don't forget to mark the thread as "Solved".

[chasoe]

Yes, it's OK now.
Many thanks.