Pasting onto filtered cells
 

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 data
adjacent to ONLY those rows. Then remove the filter.

Thank you!

M.E.


--
Mediaexcel
------------------------------------------------------------------------
Mediaexcel's Profile: http://www.excelforum.com/member.php...fo&userid=8529
View this thread: http://www.excelforum.com/showthread...hreadid=272884

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

--
Regards
Frank Kabel
Frankfurt, Germany


Mediaexcel wrote:
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 data
adjacent to ONLY those rows. Then remove the filter.

Thank you!

M.E.