Forum Discussion
NSK-Mar
Nov 17, 2019Copper Contributor
Paste TO visible cells only in a filtered cells only
I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks
kanthrishi
May 20, 2022Copper Contributor
We cant do it has values, but using simple formula we can achieve it as below:-
Step 1:- Please copy values you wanted and paste them in separate excel and name each row with numbers in sequence.
Step 2:- Filter the cells to which the values needed to pasted , in another column i.e, not in the cells you want to paste update it with numbers in sequence .
Step 3: Use Vlook up with look up value from step2 sequence updated and look up array from Step 1 sequence , and use column as required . you will get the values.
Break the link of the file and go on.
Hope this is useful.
Thanks
Kanthrishi
WaltB
May 21, 2022Copper Contributor
kanthrishi Thanks for that. I think there are several possible workarounds. Myself, I simply sorted my data and then used xlookup to populate the data I lost, from a backup. The point isn't how to do this. Its that we shouldn't have to. I can't see any reason for filtering to work the way it does. I think Microsoft should change the default behaviour to only paste into the filtered cells.