Copy from filtered cells and paste to another column

Hello

In my spreadsheet of 97,000+ rows, I have filtered some cells and wish to paste them to another column. However I find that it pastes the values to hidden cells. I have tried to use the Home - Editing - Go To Special - Visible cells only but I can't seem to get it to work.
This was working before and I cannot understand what I have done to change this. The file is saved as an Excel Workbook, and I am currently using Excel 2013.

Thanks
flox

Hi
Select Ctrl+C -> Ctrl+G ->Alt+S->Visible Cells only and Paste

Punnam

Hi P

I'm afraid it did not work....