I can't copy & paste on a spreadsheet with filter.

Spreadsheet are basically just the same.

But there is another column on spreadsheet 1 that is encoded with values(just text)
and i can't paste it on the masterfile with the same filter and all.
I have 700+ texts to paste but it only captures 46 texts.

This is with excel 365.

In the past i'm having no problem with excel 2007 - 10.
I'm using the alt +; and paste special (skip blanks)

now its not working.

Please help me and i dont want the spreadsheet converted to macro or use codes.

Since i copy and paste in a daily basis with hidden rows.