... what we're talking about
We like to keep our website visitors up to date on our recently completed projects and the latest product news. We also share useful tips and hints to get the most out of Microsoft Excel. Click on "Subscribe to Posts" to receive notification of new Announcements as they are posted. 

You can also follow us through one of the sites below to get the latest Announcements
XLAutomation on LinkedIn.


"Once I spoke with Scott, the deal was sealed!" Latest Positive Customer feedback

posted May 8, 2017, 10:42 PM by Lisa Lindsay

"Scott was very understanding of our situation and requirements for data collection and reporting, assuring he could provide an easy to use database with custom reporting capabilities, which he did. The level of communication with XLAutomation and Scott's availability via email, phone and team viewer made the whole process easy and stress free. The project was completed in the set time frame, and the price was very competitive. The outcome has not only made our duties easier, but we are also receiving positive feedback on the new reporting system from the ACT Government to whom we send the custom reports. I would not hesitate to recommend XLAutomation."

More great feedback from happy Share Trade Tracker users.

posted Apr 20, 2016, 5:49 PM by Lisa Lindsay   [ updated Apr 20, 2016, 6:07 PM ]

"Our Experiences with Scott and his team have been first class in all area's of the build, implementation and ongoing support. Not only do we personally use Share Trade Tracker in our own business, we confidently provide it to our clients as well"

Nick Radge
Head of Trading & Research, The Chartist         

"I use Share Trade Tracker , it is a very good tool that reflects the level of competence in Excel automation that Scott and his team at XLAutomation. They are readily available and provide fast feedback and solutions when required. I highly recommend the use of XLAutomation for anyone targeting better tools and excellent support for their business"

Best Regards, Said Bitar


Attention all Share Traders

posted May 25, 2015, 10:09 PM by Lisa Lindsay   [ updated May 25, 2015, 10:12 PM ]

XLAutomation are proud to announce that a new and improved version of Share Trade Tracker our most popular Excel Spreadsheet is ready for download.   

Our development team have worked closely with share industry experts to deliver features and functions that traders really need. 
Click Here to view Share Trade Tracker details.

To celebrate the release of the New & Improved Share Trade Tracker we are offering a 50% discount off the licence cost!

To take advantage of this once only offer
purchase your copy of Share Trade Tracker by the 12th June, 2015 
and receive a 50% discount off the licence cost.

Simply use the coupon code: "UVP61" during checkout to secure the discount.

Buttons in my Excel Worksheet no longer work

posted Dec 18, 2014, 2:35 AM by Scott Lindsay   [ updated Dec 18, 2014, 2:38 AM ]

In early December, 2014 a number of our customers started reporting an issue with some of our Excel spreadsheets. Basically that the buttons on those worksheets were no longer working. We have now determined that this problems is a direct result of a Microsoft security update (KB2553154), that has inadvertently disabled the capability of the buttons within all Excel workbooks on the affected computers.

Here is a screen shot from an Excel workbook that uses a button to execute a macro. If your computer has been affected by the Microsoft security update then the button will not function.

A workaround to this problem can be found in our Frequently Asked Questions section. Refer to the following link to access that solution.

7 easy steps to achieve what you need from your Excel spreadsheets !

posted Nov 13, 2014, 9:54 PM by Lisa Lindsay   [ updated Nov 13, 2014, 9:56 PM ]

Step 1 - Send us a quick email using our Contact Us form and let us know what you need fixed, changed, automated or custom developed with Microsoft Excel in your business.  

You know your business better than anyone.  Sometimes it may seem easier just to keep the business processes you have, even though you know change is needed to grow.  It might be as simple as automating a task to free up an employees time for more productive work.  Or you might have a concept that you know will improve your business but not quite sure how to make it happen.  Our team of Excel Consultants are ready to work with you every step of the way, turning your knowledge of what need into a workable Excel solution to meet your unique business requirements.      

Click Here to see the 7 easy steps involved in our Excel Consulting Process

XLAutomation goes to the northern tip of Australia - Thursday Island

posted May 15, 2014, 10:59 PM by Lisa Lindsay   [ updated May 15, 2014, 11:15 PM by Scott Lindsay ]

Thursday Island Pharmacy owner Mick Delaney came to XLAutomation with the need to turn their raw data into a set of functional and usable reports. The project involved the creation of an Excel Reporting Workbook that provided access to functions and macros to import, format and produce the required reports. These reports included picking slips, shelf labels, a standard drug list and order forms.
Alpha Standard Drug List Report

Customer Testimonial

"I found Scott Lindsay easy to deal with, patient and quick to respond to queries.  Working with XLAutomation we have achieved simplified processes and improved quality. We are also saving time, money and have happier staff, overall a positive outcome"
Mick Delaney
Thursday Island Pharmacy

Free Useful Macros Workbook

posted May 1, 2014, 5:48 PM by Scott Lindsay   [ updated May 1, 2014, 5:52 PM ]

A new Free Excel workbook has been uploaded to the Free Spreadsheets & Templates section of our website.

Click Here to access the useful macros workbook

This new workbook includes a series of macro's that automate tedious and laborious Excel tasks. The macro's have been developed by the XLAutomation consulting team in an effort to speed up our spreadsheet development. We hope that you find these macro's useful in your workbooks. The first macro to be included is.....

UnMerge & Duplicate
This macro will unmerge cells and duplicate the data from the merged cells into each cell in that merged cell. It is particularly useful when you receive a worksheet that includes many merged cells that you want to convert and use in a pivot report.

UnMerge and Duplicate Cells

XLAutomation goes Google

posted Mar 17, 2014, 2:27 PM by Scott Lindsay   [ updated Apr 10, 2014, 9:33 PM by Lisa Lindsay ]

At XLAutomation we recently reviewed our use of email, document storage and backup. Like many small businesses we had started with the available tools like Microsoft Office that existed on our desktop computers. 

In an effort to make our business more mobile and to improve our backup capabilities we looked into "cloud based" offerings that could deliver an environment in which our email, calendars, documents could be available whenever and wherever we might need them. 

There are solutions that focus on file based synchronisation to the cloud but don't offer email and calendaring (eg Dropbox, SugarSync). The one solution we looked at that could deliver everything we were looking for was Google Apps for Business. For a monthly cost of $5 per user we now have the following services available to all staff at XLAutomation
  • Email - delegated access
  • Calendar
  • File storage - with the ability to share and collaborate with Team Members and Customers
  • Google Documents - a different approach to Office documents that we will be extending to our Customers
  • Website - we have just launched our website using Google Sites which has removed the need for hosting and a separate Content Management System
Google Apps for Business

One of the features we have been most impressed with is the support you receive when you encounter a problem. It can start with email or a phone call and the response is immediate and usually solves the issue in the first call. For me this is one of the main reasons I would recommend Google Apps for Business to others.

Job Scheduling Project completed for T&T Kitchen Design

posted Dec 2, 2013, 3:34 PM by Kyle Horst   [ updated Mar 28, 2014, 2:18 AM by Scott Lindsay ]

A recent project success story for the XLAutomation development team

T&T Kitchen Designs came to XLAutomation with a need to automate the scheduling of jobs for his kitchen design business. They had a standard job timeline that was split between back office, workshop and installation activities. They wanted a solution that would calculate the next available slot for a new job and then schedule those activities into a calendar for his staff to work from. See below a screenshot of the Summary Calendar of jobs that is calculated from the current list of jobs...

Job Scheduling Summary

"The team at XLAutomation understood my very vague description and transferred it into the perfect result with ease and attention to detail. A great result, well done..!!" - Adam, T&T Kitchen Designs

1-9 of 9