DATA TRANSFER IN EXCEL

HI EXPERTS !

I AM EXPORTING ONE FILE FROM TC -FS10N BUT WHEN I AM COPYING ONE COLUMN (ITS BEEN FILTERED IN EXCEL SHEET )FROM ONE EXCEL SHEET TO ANOTHER SHEET ITS SHOWING ERROR '

MICROSOFT CAN'T CREATE OR USE DATA RANGE REFERNCE BECOZ IT IS TOO COMPLEX .TRY ONE MORE OR MORE OF FOLLOWING .'

CAN ANYBODY SOLVE THIS .