Forum Discussion

KAM_Mumin's avatar
KAM_Mumin
Copper Contributor
Oct 23, 2022
Solved

MS EXCEL Copy Paste Multipal Values in Multipal Filtered Cell/Colunm.

Hi Everyone!

I want to paste my copied multipal values from a sheet into a filtered column but when I do that the pasted values are not pasting in the filtered rows,, is there any way to paste the copied value in the filtered cell?

Please any of you have a solution then please reply.... I attach below some screenshort for understanding..,,

 

developer
excel
Formulas and Functions
Macros and VBA
office 365
Office Scripts
  • HansVogelaar's avatar
    HansVogelaar
    Oct 23, 2022

    KAM_Mumin 

    One workaround is to sort the target range so that the cells you want to paste to are in a contiguous range, instead of filtering the target range.

    If you prefer to keep the target range filtered, you need a macro - see this post 

2 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 23, 2022

    KAM_Mumin 

    One workaround is to sort the target range so that the cells you want to paste to are in a contiguous range, instead of filtering the target range.

    If you prefer to keep the target range filtered, you need a macro - see this post 

    • KAM_Mumin's avatar
      KAM_Mumin
      Copper Contributor
      Oct 24, 2022
      Thanks a lot bro for helping, the code mentioned in the post works great,,

Resources