Latest Articles
Import CSV file to Excel Sheet
Code to import comma Delimited CSV file to a sheet in Excel.
Chocolate Pancakes
A different take on a pancake.
Ham pastry pizzas
These pretty spiral pastry pizzas are a great way of using up any leftover ham and work just as well…
Pivoting in SQL
Pivoting can be useful when the data needs to be modelled/flipped before it gets to the target.
Rows and Columns functions
Useful information if VBA operations need to be performed on Columns or Rows.