LinkBack URL
About LinkBacks
Hi. I'm using XL / Kutools & looking to find duplicate cells across 2 worksheets, and then somehow delete the duplicates in one of the sheets.
TIA
Hi. I'm using XL / Kutools & looking to find duplicate cells across 2 worksheets, and then somehow delete the duplicates in one of the sheets.
TIA
Last edited by Nickkmal; 04-13-2022 at 02:27 AM.
Welcome to the forum.
If you want help with KuTools (which is a paid add-in), please contact the KuTools developers. What you want to do can't be done natively without VBA.
Administrative Note:
Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks Ali. I suppose I will have to get my head round VBA!
Do you happen to know how I would do this using VBA?
Many thanks again
No idea, sorry - I don't do VBA. I will move this to the VBA section for you.
Thanks ALi!
Please update your profile as requested in post #2 while waiting for help. Thanks.
When I do this I use the VBA Dictionary function. Look at this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks