I was able to apply this to my workbook with my data in it fairly easily. It didn't work exactly as you had it in the example sheet; to make it work I had to change it from
to
The IF was just to show a blank instead of a 0 if there was no info to draw from, and for each column I moved to the right I had to increment the -8 at the end (so for the very last column, units, it ended up being +2). This works perfectly for what I need, and your explanation of how OFFSET works was definitely helpful for tweaking the code a tiny bit. Thanks again for the help!
Bookmarks