Custom Spreadsheets

A lot of the time when you are doing repetitive stuff with spreadsheets, especially if you have to do it every month, it can get tedious and worse, take up valuable hours of your time.

We can “probably” design you a custom spreadsheet that will do the repetitive work for you at the touch of a button.

Not a lot of people realise that Microsoft Excel has it’s own programming language hidden in the background. Using this programming language you can write code that automates the things you do manually. Even better than that, it does it really quickly.

Say you have a thousand customers names and addresses in one column in a spreadsheet, and you need to separate the first name, second name, house no, town etc into separate columns. If you had to do this manually it would probably take you a minute per name & address.

So a thousand name list might take you a good few hours, and that’s being generous. ┬áIf we wrote a bit of code to make the spreadsheet do it automatically it would take it less than a minute or two to complete the task.

Can you see the potential time saving here?

If you do a lot of repetitive spreadsheet work, contact us here, we may be able to make it a lot easier for you!