Problems copying filtered data

[HIV 7]

Hi experts,


i just watched some videos and read some site about my topic, but I really have not found a solution for what I thought it has been working in the past ....


I Atached two Files as an example of what I mean (one Word containig Screenshots and the Excel File I used), I have 10 rows and two columns. In columns one is M or W and in Column 2 there is a number.
What I need to do is to copy the data of Column 2 in Column 5 (as my excel is an example), but I have an active filtering in COlumn 1 on the criteria M.




Can someone help me to get this done? I tried only copy vsible cells/rows, but that does not bring me up to what I need.


Would be so great to hear from you experts if there is a solution for this topic.


Kr, HIV 7