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.
VBA Functions
In VBA there are Subs and Functions. The main difference between the two is that the Function can return a…