How To Select Last 90 Elements In Filtered Column VBA

I have about 6000 rows of data in column A:G and growing

Column A is the key where i filter between a lot of duplicates

If i filter on X100000 there is about 432 elements (rows)
if i filter on Y100100 there is only 43 elements (rows)

The problem is i only want to copy the last up to 90 element to another sheet. I can copy all 432 rows to a second sheet and then copy last up to 90 rows thats what im doing now. And i am familiar with

"Selection.SpecialCells(xlCellTypeVisible).Select"

But still cant figure out haw to do it directly in the filtered sheet.