Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Prevent duplicate data entries from being imported from the Web.


Hello, I am a beginner at excel. I am trying to import some data from charts that are on the web using this method:

-Data Tab

-From Web

-Entered Web address.

-Clicked on the yellow arrow where the chart is located on the web page (yellow box, turned green)

-Clicked on Import

THIS IS WHERE MY PROBLEM IS. When the chart loads there are duplicate entries with slightly different variables. Is there a macro or formula that I can utilize to remove the duplicate entries permanently, everytime I am going to refresh the data from the web?




The easiest way is to go to the data tab and click the Remove Duplicates button.

A macro can be created to automated the use of this feature but might not really be worth it since it's so easy to remove duplicates in Excel 2007.

If your data "duplicates" have variations though, you would need to provide a sample of the data and then, depending on the situation, a macro could be made to remove all entries that have a certain pattern.


Answer the Question

You must create an account to use the forum. Create an Account or Login