Pieter Bollen 12 blogposts

In this blog post, I’ll let you in on a date formatting trick. I’m not talking about date formatting through Format Cells, but about the date format you enter manually when using the TEXT function. 

Can’t get enough of Excel? Good! In this blog post, we’ll teach you another Excel trick. When Microsoft introduced tables in Excel in 2007, it became impossible to use the dollar sign ($) to lock rows or columns. This isn’t much of a problem for rows, but what about columns? Read on – I’ll explain how you can still lock these.

This is the seventh and last blog post in our series about how you can speed up data transformation in Excel VBA. In this blog post, we’ll discuss how you can merge two tables and add them to one recordset. 

This is the sixth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In the previous blog post, we explained how you can save data in a recordset. This time, we’ll show you how to use this technique to open all files in a folder and transfer their data to a target file. 

This is the fifth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In this blog post, we’ll explain how you can save data in a recordset.

This is the fourth in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. This blog post is a variation on the example from our previous blog post, where we transferred data from one file to a target file: this time, we’ll transfer data from multiple files.

This is the third post in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. This blog post teaches you how to open a file and transfer data to a target file. It’s an introduction to the next posts in this series.

This is the second in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. In this blog post, we’ll show you how much time you can save when adding a large number of cells to a table. 

This is the first in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In this blog post, you’ll learn how to save time by making certain cells equal to others instead of copy-pasting separate cells/ranges.