Author

John

Started out in media/graphic design then moved to Financial Services / MI data / Business intelligence. ~15 years experience of Excel / VBA , and more recently Qliksense , SQL

London, UK 25 posts
Text to Clipboard with Office 365 / 64-bit

Text to Clipboard with Office 365 / 64-bit

Depending on which version of Excel you're using, you may find you're no long able to dump out text into the clipboard in VBA like you used to. I found an interesting bit of Win 10 /64-bit safe code on Stack Overflow -Original Stack Overflow Post. I'm presenting here in...
Read more
Colour by code in Excel with VBA - Part 3

Colour by code in Excel with VBA - Part 3

Following on from the previous entries  ( * see page list )  , in this post, we'll be looking at a few more methods to colour ranges / cells to achieve easy visual categorisation. Here's a few quick scripts / examples that you can use in your own projects. These...
Read more
Get fast in Excel! Shortcuts to speed up your workflow.

Get fast in Excel! Shortcuts to speed up your workflow.

Have you ever been frustrated scrolling through a huge spreadsheet, or filling out blocks of data a cell at a time?   Read on, as below are a number of shortcuts that'll save you time and energy in your daily chores!   CTRL + Spacebar   / SHIFT + Spacebar   Tired of clicking...
Read more
SQL connections and data import into Excel

SQL connections and data import into Excel

You might have some sophisticated BI tools like OBIEE  / QlikSense /  Power BI etc. , however sometimes it's useful to be able to prototype, or access tables / stored procedures etc directly through Excel. This can be slow and cumbersome working through Excel's query editor, especially if you're already...
Read more
Selectively Delete Columns/Rows by content

Selectively Delete Columns/Rows by content

Do you often download or received spreadsheets with a large number of rows/columns that are surplus to requirement?   If so, read on, as these two UDF methods can save a lot of manual filtering and deleting!   Prerequisites  You'll need two additional functions, Ron De Bruin's 'Last' function that picks the...
Read more