Excel VBA IntroductionVBA stands for Visual Basic for Applications and is an implementation of Microsoft’s event-driven programming language Visual Basic […] September 15, 2018 in Excel tagged VBA / introduction / macro / Excel VBA by Mike
Export Trello to Excel to Access to ExcelTrello is an open source web based project management application which organizes your project information into boards. A […] September 4, 2018 in Excel tagged project / management / import / access / Trello / excel / export by Mike
Excel Convert Url Text To Clickable HyperlinkSupposing you have multiple URLs in your worksheet, but they are not linked, and now you need to […] September 4, 2018 in Excel tagged excel / VBA / hyperlink by Mike
Create Table SQL Script in ExcelYou have some data in Excel that you need to import into SQL Server. You don’t have a […] April 15, 2018 in Excel tagged create / transpose / pivot / excel / sql / import / table by Mike
Excel Combine Worksheet DataThe objective for this post is to learn how to combine (merge) more than one Excel worksheet file […] February 20, 2018 in Excel tagged data / excel / VBA / combine / merge by Mike