transform information from rows in unranked order

[ossa]

hello!

I have a sheet with information in row 356, 360, 380, 382, these are in order when I am using a filter. I would like to transform this information to another sheet in row 5,6,7,8. I dont what to just copy text, but I want the first rows to be the source. F.ex cell sheet1!A356=sheet2!A5. Hope I made myself clear, thanks for any reply!

Ossa

[bongaan]

Book1.xlsm

The only way is to do it with a vlookup, see attached sheets1 with the filter and sheets2 where the vlookup is used. You will have to number your data with a unique number like in my example