Combine Excel Ranges (without VBA)
I’ve been finishing off a project modifying a client’s existing spreadsheets. The spreadsheet allows a courier company to log various aspects of its delivery business each day with one worksheet for each day. One aspect they log is failed deliveries. One each day’s tab, there’s a table for delivery issues and another for failed deliveries.So far, so […]
Continue readingSpeed Up Data Entry in Excel with Prompts
Have you ever created a spreadsheet people used to enter data? A bit like a data entry form, but on a worksheet?You may have wondered how to make the form more intuitive. That way your users knew what they should enter in each field.If that’s the case, this post is for you.Making Data Entry More […]
Continue reading