Hi Experts,
In my daily data entry work, I often happen to copy non-filtered data (from a different work sheet) and paste those to a filtered cells of a different work sheet. In other words, the same information in another work sheet has to be copied to a work sheet that has multiple information which can be filtered to match the copied information from the other work sheet.
I tried to find a solution, but failed. I just installed Kutools also, but I don't know how to used it for this purpose.
Is there a way through excel? or does Kutools have any option to do this?
Thanks.
Bookmarks