vba

What if there was an Excel Tool that did most of the things you try to do each day? Comparing two columns to figure out which is different. Or close all your open workbooks, saving some and not others? How about increasing a range of cells by a certain percentage markup? Using my 20+ years with Excel proficiency I have developed a free Excel tool that I share with users. It's free because I want to help people who like me search for solutions from people rather than companies. You can get my XLSuperTool at this link. But what if you need more detailed help with your Excel spreadsheet or workbook project? I have helped people from all sorts of industries; Logistics, freight forwarding, banking and finance, personal fitness, warehousing, and sales. See experience. Since 2007, I have had a presence on MrExcel which is a very helpful forum for quick Excel-based questions.

So you want to use Excel to act like a database, after all a database is mainly a list of lists right? Well, most databases such as SQL databases are very complex and almost convoluted in how they relate to data via primary keys and such. Did I lose you? Okay, then back to Excel, something you and I both can understand right? I've been using Excel for over 20 years and have now designed an easy to use process to make Excel behave like a simple database. Granted, this wasn't really feasible in the past as not until Excel version 2007 could you store more than 65,536 rows of data on each tab. Now you can store 1,048,576 rows. Now we're talking!!!