Forum Discussion

Muthukumar_Natesan's avatar
Muthukumar_Natesan
Copper Contributor
Sep 28, 2022

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...
excel
Muthukumar_Natesan's avatar
Muthukumar_Natesan
Copper Contributor
Oct 09, 2022
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.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 09, 2022

    Muthukumar_Natesan 

    I suspect that you haven't actually tried that macro. I have tested it and it does exactly what you want.

    • Muthukumar_Natesan's avatar
      Muthukumar_Natesan
      Copper Contributor
      Oct 09, 2022
      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?

Resources