Filtered Cells Only

[kate.middleton1]

Hello Everybody,
Although i have asked the same question in this forum now i have change little bit of my code, Actually i just want to consider the visible cells only.
For the sake of example please see the attached workbook.

[GaidenFocus]

try this, substitute rng for your range

Please Login or Register  to view this content.

[hakuna.matata]

But how does this works? I don t want to copy the data i just want to consider the visible cells of both sheets

[GaidenFocus]

what do you mean by consider?

[hakuna.matata]

I mean that only visible cells of sheet1 is compared with visible cells of sheet2 when found then write double in sheet1 for that founded cell.