Assignment: I created this macro at Rockefeller so I wouldn't have to manually shift the cells over every quarter. I also, wrote a summary macro for the aggregate sheet that would total the number of Inpatient visits, Outpatient visits, and on-call shifts in the corresponding cells on the summary sheet.

Category: Programming

Status: Finished

Languages: VBA

Libraries: Visual Basic For Applications, Microsoft Excel 12.0 Object Library, and Microsoft Office 12.0 Object Library

Software: MS Excel