Macros

Macro to fix Duplicated Conditional Formatting rules in Tables

Note this only works for Tables.  One day I will adapt this code for a 2nd macro to work with a specified range. Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated Conditional Formatting rules.  I tweeked this […]

Macro to fix Duplicated Conditional Formatting rules in Tables Read More »

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries

So this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system.  See here for Part A.  This example concerns automating entries on your bank statement you can reliably identify.  In my case it was to record bank transfers from my cheque account to an interest

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »

Exporting to PDF

I had a small, interesting job involving exporting to PDF last week where the client had an .xlt template with existing in-house VBA to let the user save certifying documents within the an .xls file to a default folder plus “print to pdf” ie creating a pdf file and saving it to a user chosen

Exporting to PDF Read More »