Paste data in filtered cell

[salahuddin]

i have 2 sheet.
in sheet A raw data have been filtered.
i want to copy sheet B data to sheet A filtered data.
But when i copy sheet B data and paste it into sheet A it paste to all column but not the filtered column.

 

[NARAYANK991]

Hi ,

Filtering works only on rows , not columns ; do you mean hidden columns ?

Can you upload your workbook , and then explain your problem in more detail ?

Narayan

 

[salahuddin]

Dear NARAYANK991
Thank u for your response.
I am very much tense about the matter.
You right its row.
In demo file, i want to copy the sheet2 cell C3 to C13 data
and paste into sheet LOAN E1 to E62
without paste to filtered data.
ie i want to pase to E2, E8, E14, E20, E26, E32 etc.

 

[NARAYANK991]

Hi ,

This is not so straightforward.

Please go through this blog and see if you can implement what is shown and explained there.

http://blog.contextures.com/archives/2014/04/24/problems-pasting-in-an-excel-filtered-list/

Narayan