Problems selecting the correct data

[ForeverArsenal]

Hi all,

I am trying to build a macro to perform what I thought was a simple instruction but has turned out to be a nightmare.

Scenario:
My sheet has filters and I want to remove the listings (15 cells per row) where column 5 filter = 100%
I then want it to paste into another sheet and then insert the entry date into the cell at the end.

I have tried using dim integers but getting no where. Obviously a filtered set of units is obstructing the process.

Please, please please, if anyone has any ideas.

thanks

ForeverArsenal