Excel tips, tricks and tutorials for healthcare professionals.
A collection of 9 posts
A while ago I published a post that demonstrated how to use a macro to generate multiple pdf files for distribution, by working through a filtered list. I’ve recently acquired a macro solution to do something similar but in this...
This is a fantastic little macro that I picked up from The Spreadsheet Guru
We generate reports that hold details for multiple practices all in one sheet, which is nice and convenient for me as I can run a pivot table off it and analyse any number of practices and services as I see...
I often find myself struggling to deal with data that has been rendered almost unusable by the data provider who has converted it to a cross tab format. Usually they think they are helping and have probably started with a...
When you first start to dabble with macros and VBA, one of the first challenges you will face is fathoming out what to do with the personal macro workbook.