VBA

Macro to fix Duplicated Conditional Formatting rules in Tables

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 code just a bit so that all you have to do is select anywhere in any Table in the active worksheet and it …

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

Check range for specific characters – Customizing the Ribbon

Update 11/08/21 Well two interesting recent developments have occurred regarding this post! Microsoft MVP Rick Rothstein kindly contacted me about much more elegant code than I have below, trying to assign 6 table columns to a range variable so the macro would operate on selected table columns (not all). So I have just the relevent …

Check range for specific characters – Customizing the Ribbon 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 »