PDA

View Full Version : Creating a VBA to find and delete duplicate values within Excel workbook



NickJek
12-17-2022, 09:31 AM
Hello,

I am searching a way to find and replace/delete duplicates of the particular list of data (lets say, positioned in column A, Sheet 1) in the entire Excel workbook.
What i mean is, if this is my data (in column A), is there a way to find all the duplicate values in Sheet 2, 3 et cetera and delete them, based on this list ?

Thank you in advance for you time and cooperation!