Sometimes, when you import information to an worksheet from another workbook, empty rows (because of a formula which returns a '0') or perhaps unwanted information could be imported as well. I make use of the following code to 'clean' the imported data. It is easy to extend and adapt the code to your needs. I will show … Continue reading Delete rows on condition vba
Ever wanted to send information from one workbook to another? After reading this article you will understand how to do so by making use of VBA. Two workbooks are used: Database.xlsx (the file that collects all the information from 2.) Information_send.xlsm (the user file which contains information that has to be send to a (hidden) database. … Continue reading Send information to Excel database
This article describes how to create buttons in Excel. Buttons are useful for different kind of tasks, for example: printing out a page or to automate a calculation procedure.
In this article different print methods are described in order to Excel pages via a button or by simply using the macro menu.