how do i paste data to visible cells only (without vba)

[salahuddin]

i have data in sheet 1 and i want it to paste sheet 2.
sheet 1 have data c5: e244.
and i want paste it to sheet 2 e:g filtered cell only.

would u please help me to solve it.
here is my demo file.

 

[vletm]

salahuddin
1) if You want to copy&paste then row-by-row

2) if You would use formula then:
Sheet2::
a) write to E5 =VLOOKUP(D5,Sheet1!$C$6:$E$244,2,FALSE)
write to F5 =VLOOKUP(D5;Sheet1!$C$6:$E$244,3,FALSE)
b) UnFilter Your data
c) Select range E5:F13
d) press Ctrl+C
e) Select range E14:F2155
f) Press Ctrl+V
g) Select range E5:F2155
h) press Ctrl+C
i) Select range E5
j) Make Special Paste - only values
k) Filter Your data as it was in the beginning

 

[salahuddin]

Dear vletm
thank u, thank u very much
its working, i am very glad to see this.
its help me very much.