Posts tagged "Excel VBA"

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheet using VBA. Assuming that you have a little bit of knowledge on SQL server. Now if you are preparing reports in Excel and the data is in your SQL server then you don’t need to copy the data first from SQL server to […]

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to password protect Excel Sheet based on the User as part of excel vba tutorial. For Example, you have a master excel sheet in your centralised location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to […]

Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a custom VBA autofilter in excel. This Advanced Excel filter technique is meant for advanced excel users.  We all know how to use a custom filter or advanced filter in Excel. Here we will discuss creating custom Excel VBA autofilter For example, you have a huge […]

Merge Excel Files into a Spreadsheet using Excel Macro

In this blog, we will try to cover how to merge excel files into a single sheet from a different workbook using excel macro. In the earlier blogs, we have covered how to merge data in a single sheet when the data are coming from the same sheet. If you don’t follow our blog, then […]

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate spreadsheets but this time, we will split spreadsheet records into a new workbook. It’s useful and reduce our effort in making different workbook with same data. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“. Here’s how we […]

Merge excel files into a single excel spreadsheet [VBA Tutorial]

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook. Let’s learn how to merge excel files in a single excel with an example: […]

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one . This can […]

Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S. […]

error: Content is protected !!