Copying and pasting pre-filtered results into same row number?

[Twomsta]

Hi all,

Hopefully I've posted this in the correct area of the forum!

For the sake of context what I have done thus far is categorized rainfall levels into 3 threshold points. e.g.

'rain_event': => 5mm/day

'Significant': => 25mm/day

'Heavy': => 100mm/day

In order to do this I used the following formula:

=IF(F2>=100,"HEAVY",IF(F2>=25,"SIGNIFICANT",IF(F2>=5,"Rain_Event",IF(F2<5,"N"))))

The corresponding (adjacent) column now includes the name of the threshold (e.g. 'significant')

I then filtered the worksheet removing all rows with 'N' (i.e. non events)

What I now need to do is copy and paste the results/data into a new worksheet whilst retaining the same numbered cell position (i.e. row number) with regards to the 'y' axis (the column position will not matter). Presently, when copying and pasting the results they are all pasted below each other.

If this makes sense and someone can help me it'd be greatly appreciated. If its too confusing I will make up some simple visual examples of what I need in terms of before and after!

Thanks!