Excel – 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 - Excel – Automating Tasks with the Macro Recorder – First Steps »
Excel – 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 - Excel – Automating Data Entry and Protecting your Data »
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.
