Pasting onto filtered cells

M

Mediaexcel

Hello,

I seached for this but could not find any solution in the forums.

I have filtered unique records in place and now I want to paste dat
adjacent to ONLY those rows. Then remove the filter.

Thank you!

M.E
 
F

Frank Kabel

Hi
try:
- select the range
- hit F5, click 'Special' and choose 'Visible cells only'
- now paste
 
Top