» 973.876.3729

DB Pros database and business consulting

» Excel Automation

If you find yourself doing the same repetitive tasks in your week or month, and they involve Excel, we may be able to automate these tasks for you.  You may think that the way you’re doing it is the only way you can make it work, but you’d be missing out on an opportunity to sit back and let the computer do it for you!

Some of the actions we can automate are:

  • Copying/pasting
  • Copying sheets in Excel
  • Filtering and/or sorting
  • Opening and closing files
  • Updating data based on patterns or data from another sheet/file
  • Calculations
  • and so much more!

We have saved our clients hours in their usual schedule by creating these automations for them, which leads to higher productivity, being able to get to projects you otherwise didn’t have time for, saved costs and many other benefits.

If you would like to find out more about our Excel Automation services, or to see if one of your existing processes will fit with this service, email us or call us at (973) 607-1627.



“We hired DB Pros to complete a merge/purge (data cleanup and consolidation) project.  We provided them with several internal customer files and a purchased Dun & Bradstreet (“D&B”) list.  The output was exactly as requested, and they made some suggestions along the way that saved us both time and money.

Overall results of the merge/purge process showed us that over 80% of the companies in the D&B list were NOT existing customers to us.  Therefore, there was an enormous opportunity to leverage this information to gain new customers.  We were also able to view our customer and product data in a succinct way by having it all in one spreadsheet together.

We plan on using DB Pros for additional merge/purge projects as our needs arise in the near future.  The work was excellent, timely and reasonably priced.” - Martin Torbert, National Starch & Chemical

“Tonar was looking for an integrated database solution that would shorten the amount of time spent and allow us to have a more efficient and accurate process. We entrusted DB Pros to create a solution and they have surpassed our expectations. We believe they created a solution that does exactly what was needed and at a reasonable price, it was a perfect fit.” – Perry Fox, Tonar Industries



I wanted to thank you for the work your team did on the excel file I sent you to prepare.  Your knowledge and expertise in recognizing and then implementing the automated process was amazing.  What used to take hours each month to manually separate and total the information required by my client, can now be done in minutes.  I look forward to working with you again soon!

- Andy Lieberman, All-Ways Advertising


Read more testimonials and case studies for our Excel Automation services.

Newsletter Signup