- select the range
- hit F5, click 'Special' and choose 'Visible cells only'
- now paste
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 data
adjacent to ONLY those rows. Then remove the filter.