In addition to our template offerings, we offer a consultancy service free of charge for Excel or VBA programming problems that can be solved relatively quickly by us. We only make a modest charge for more complex problems requiring a significant amount of time.

Don’t hesitate to click on the ‘Contact Us’ page of our website and ask for any assistance you need. We will gladly do our best to help you free of charge where little time is involved or for a modest fee to deal with more complex problems.

As our template ‘Useful Excel Tips and VBA Snippets’ says: “We live in an age where some solutions to Excel and VBA programming problems can be found on the internet. However, one of the main purposes of this workbook is to provide solutions that would in many cases be difficult to find on the internet and, therefore, save a great deal of time in searching the internet.”

Our consultancy service can help you to write some VBA code or even prepare a sample template as a simple model for you to adapt and develop to suit your individual needs.

We have listed below a small sample of situations where we can provide personalised solutions that are not readily available on the internet:

Copying a range without specifying the bottom cell number
Creating gaps between rows with conditions (when headings change, etc)
Looping through several worksheets applying the same VBA code
Matching items in 2 or more tables
Nested lookup formula for a chain of lookup values on the same or different worksheets
Totalling at the bottom of a flexible range of numbers without specifying the bottom cell reference
Totalling with conditions; eg, values between a minimum and maximum amount
Totalling multiple amounts relating to the same reference

Click on our ‘Contact Us’ page now for assistance.