Tag Archives for " Formulas "

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 reading

Speed 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