Forum Discussion
An easier way
Good morning, I've recently started working on a project and was introduced to a process that I think could be made significantly more efficient. Each month we get a download of records and we ...
HHaselti13 Power Query is your tool. First you need to create a queyr to get the values from your file. This will import all the values in to your main database. then a second query to find and eliminate the duplicates which is very dependent on the values in your main database.
to import the files you need to create a new query which is located in data tab (in excel 2013 you need to install power query seperately, it will have its own ribbon tab). The query editor is pretty easy to use and you can find lots of online free courses,like ExcelIsFun in youtube.