Excel Product function in Tableau
I stumbled across a question on the Tableau forums asking how to write the Excel Product function in Tableau. Full credit for the answer goes …
Excel unprotect workbook and worksheets using VBA
I inherited some Excel spreadsheets which had protected workbooks and worksheets, but an unprotected VBA project. I didn’t have the passwords for the Excel spreadsheets. …
Excel Populate a Combo Box from a Database
To populate a combo box on a userform in Excel you need to use VBA. Firstly add a combo box to a userform in the …
Remove a line feed / carriage return from a string
This article describes how to remove the carriage returns and line feeds in SQL, Tableau, Excel and Access. If you ever have to deal with …
Excel Insert Carriage Return or Bullet Points in a Cell
This post is a quick tip about how to insert a carriage return and bullet points into an Excel cell. How to add a carriage …