Hi all,

What I'm looking for is to Autofilter data on sheet 2 based on the text in Sh1(which can change from time to time) like the following-

Sh1 text =....., autofilter Sh2 column "A" data for ......, then also autofilter to arrange values in Sh2 data in column "B" from lowest to highest.

Then I want to copy paste various data from cells in the the first 4 rows(from the above result) to various cell positions in Sh1.

Greatly appreciated for any help given.