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 c...

developer

excel

Formulas and Functions

Macros and VBA

office 365

Office Scripts

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

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
Brass Contributor
Oct 24, 2022
Thanks a lot bro for helping, the code mentioned in the post works great,,

Forum Discussion

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

Resources