Pasting values in a list already filtered

Hello everyone,

I would like to paste values from a list into a different list - different tab - that is already filtered. When I try to do so, the values will paste into the hidden cells - being filtered -.

Find attached an easy example of my problem. The list I am talking about is around 1,000 lines.

Pasting Example.xlsx

To explain my example, I filter sheet 1 so only item I need are showing - B, D and F in this case - and I would like to paste the value of Alarm 3 from the Sheet 2 to the corresponding line in sheet 1. But it does not really work - line F is not filled - and when I un-filter values are filled into Item C and D. It works if I do one by one but in my case that would take me ages and I am sure there is another solution instead of doing thousands of copy/paste. It is just I am not an expert yet :D

Is it possible to do so?

I am a fairly beginner so I know nothing about VBA and programming stuff.


Thank you very much

I have applied your equation to my workshop. It works it is amazing!!!

Thank you so much!! And it was so fast for the reply as well!!

I wonder if you see Excell like Neo sees the Matrix to come up with solutions like this!!

Cheers