ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pasting onto filtered cells (https://www.excelbanter.com/excel-worksheet-functions/5131-pasting-onto-filtered-cells.html)

Mediaexcel October 27th 04 05:38 PM

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


Frank Kabel October 27th 04 05:44 PM

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.



All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com