Copy and paste while filter

[neerajagarwal2050]

Hi,

Greetings!!

Whenever I filter my data into File 1 and copy data from File 2 and then try to paste the data in File 1 then data get pasted into invisible cells as well.

Appreciate your help.

 

[udprocks]

hi neeraj,

i think its not possible to paste data in filter cell...

 

[neerajagarwal2050]

I know Sir its really hard for me to find the solution but still tried to check if any excel ninja has overvome this issue.