Forum Discussion
Pasting values to visible cells only
I want to copy values from a particular column in an excel file and paste it in another file in a particular column where I have excluded some rows by means of filtering. However when I paste the val...
See this reply for a macro that will do what you want.
- Hi Hans,
Thanks for your prompt response. This macro will not solve the issue that I reported. Let me try to explain better:
1) Opened an excel file FIle_A and copied 20 rows of column B from this file. Please note that there is no filter applied in File_A.
2) Opened another excel file File_B and filtered column A that lists only 20 rows. Now I tried to paste the contents that I copied from File_A.
After the completion of the 2nd step, I expect that contents that I copied from File_A should be copied to the visible cells in File_B. However it is not happening. The contents are copies to the cells that are hidden (filtered out) in File B.I suspect that you haven't actually tried that macro. I have tested it and it does exactly what you want.
- Hi Hans,
Thanks a lot. I tried it again today. It worked. I am not sure what I missed when I did last time. I tried with 2 example and it worked. Thanks a ton :-). Is there a way to place a feature request to Microsoft to implement this feature and include it under the existing "Paste Special" menu item?
