Copy and paste filter value

[vjharry]

Actually my Basic question is how can I copy data from filtered data and paste in visible cells only

For Example I have copied Row no. 2,4,6 fro this GREEN table and want to paste same date in J and K column (in same row numbers)then how can I do this ?

File is attached for ref.

 

[hateme28]

I do not see a file attached. are you looking for a formula? something like =C2. or do you want vba code?

 

[vjharry]

I do not see a file attached. are you looking for a formula? something like =C2. or do you want vba code?

Hi I m not able to attach any file so putting here FB link where file is saved

https://www.facebook.com/download/preview/300736453429797