Automating Tasks with the Macro Recorder - First Steps
If you haven’t noticed, I am a huge proponent of automating everyday tasks with Excel. I’ve talked about things that you can do natively (within Excel itself), but this time I’m going to talk about automating tasks in Excel from a behind the scenes standpoint by showing you how to access the programming end of [...]
Read More About - Automating Tasks with the Macro Recorder - First Steps »
Automating Data Entry and Protecting your Data
How many times have you sent out a workbook for users to fill in data, only to have them delete or somehow screw up your formulas? Or have a complete workbook that has a lot of formulas dependent on data entry and you accidentally overwrite or delete an essential formula? I’ve done it many times, [...]
Read More About - Automating Data Entry and Protecting your Data »
Automating Data Entry with Data Validation Lists
Data Validation is one of Excel’s most underutilized tools from a data entry perspective, especially its ability to manage list type functions. What is Data Validation? Well it’s essentially a robust set of tools that allow you to define the parameters you want for certain data entry cells. In other words, you can control what [...]
Read More About - Automating Data Entry with Data Validation Lists »
Welcome to the World of Smitticisms
A brief introduction to the Witticisms of Smitty (i.e. - Smitticisms), bringing help, instruction and inspiration to all levels of Microsoft Excel users and programmers.
