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 [...]
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, [...]
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.