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 values, the values get pasted in the rows that are hidden. I checked extensively in the net to find a solution for it, but I didn't get any direct solution but only work arounds. I understand that there is a third party vendor (Kutools) who has solution for it, but I am looking for a solution from Microsoft.
9 Replies
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.
