Download printable fact sheets or clever automated files to make your work life easier
I have created a data validation rule that checks new entries to ensure they haven’t already been recorded, but when a user pastes into this worksheet, the data validation doesn’t work. How can I prevent people using paste to circumvent my data validation? Unfortunately when cells are pasted over in Excel, it’s not just the […]
How can I create a dependent drop down list? This is a question that I get all the time and while the question is simple enough – the answer is anything but. It’s going to require the creation of a dynamic named range that’ll use multiple functions nested within a single formula to make the […]
How can I import data from multiple source workbooks into separate worksheets in a single file? Although this can be achieved with links to the source file – links can easily be broken and can also make the file slow and cumbersome. So instead of creating links, I like to create processes that import the […]
Download a simple Excel based Sales Recorder that facilitates simple recording of products and/or services sales per individual transaction and allows results to be presented in whatever format is required by the user. The total sales for the prior twelve months and the sales for the requested time frame per product are visually presented on […]
If you’re working with dates in VBA – it can be a little painful when the date format defaults to US format (mm/dd/yyyy). Sure when you enter 30/10/1979 (my birthday incidentally), it knows it’s the 30th October because there is no 30th month, but when you enter 03/05/1957 (my dad’s birthday), it reads it as […]
If you’re a keyboard user (like me) and hate having to take your hands off of the keyboard to reach for the mouse… There’s a keyboard shortcut to achieve everything in Excel. Ctrl, Alt and Shift in combination with letter keys, number keys and each other are used to negate the need for your hands […]