Browsed by
Category: Macros

Creating a mini calendar inside an excel spreadsheet

Creating a mini calendar inside an excel spreadsheet

Whilst creating various turn-around-time reports, I thought it would be helpful to add a little calendar to the spreadsheet.  Here is an excel vba function that adds a mini calendar to the cell address you specify: Public Function MakeCalendar(intStartRow As Integer, intStartCol As Integer, strStartDate As String, strEnddate As String) As Boolean ‘Takes start row and column and prints a calendar. By Eric Ainsworth – www.synapsonic.com On Error GoTo Errorhandler Dim WeekDays() As String ‘little array for S-Sat WeekDays =…

Read More Read More

How to combine/copy multiple workbooks into one workbook.

How to combine/copy multiple workbooks into one workbook.

A lab billing macro example Here is another useful macro for copying data from multiple workbooks into one workbook. At the end of the month billing needs a report with all the months charges listed. We have been creating a workbook daily with the day’s charges listed. Now we have to collate all those workbooks into one workbook. Again it’s a tedious process in need of automation.

Turn-Around-Time Excel macro

Turn-Around-Time Excel macro

Once again we have reports that the system has chucked out that need a lot of work.  In this example we are reporting the turn-around-times for a monthly report.  In this example, the Cerner Powervision app gives us a report on each tests’ TAT.  This report is exported to Excel and the user counts how many tests exceeded TAT, and calculates the percent meeting target TAT. TEDIOUS!  Excel macros to the rescue: Instead of making this into a full-blown tutorial…

Read More Read More