Ever wish you could ask someone a bunch of questions and have them entered into the appropriate cells? With this macro, you can have an input box pop up asking the user to answer a question (i.e. what is your name, what is your address, etc.). By defining the user's response with a unique name, you can have the macro populate the file for you. Use the example below as a guide. … [Read more...]
Delete Hidden Rows and Columns
Sometimes we hide certain rows or columns because we don't want the data to print, or just to get it out of the way. Other times though we simply don't want to share the data in a hidden row or column. Assuming that the data in visible cells isn't dependent on the data in hidden cells (i.e. if a formula references a hidden cell), we can use the macro below to automatically … [Read more...]
Add Spaces to Empty Cells
We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Empty cells could play tricks on certain features in Excel, such as pivot tables, that read an empty cell as 0. If we don't want these cells to appear in … [Read more...]
Remove Spaces From Empty Cells
We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Cells that may appear empty really aren't, as they will often times contain spaces. Usually this isn't a problem, but sometimes pivot tables or other … [Read more...]
Create User Forms
Have you ever had a spreadsheet, where you wanted users to be able to enter information in a form, and have it populate the next available row in a given set of columns? It's easier than you thought, and will make entering data more efficient and accurate. The example below will use most of the common UserForm tools to give you a feel for how they work. You can later apply … [Read more...]