VBA to Grow/Shrink Part of a Worksheet

Assuming I can insert a picture here, I'm looking for general thoughts on how to proceed. I have a worksheet with a checkerboard-like matrix; some squares will have X's in them, reflecting the "skillsets" of the listed members. Tricky part is, I need the matrix and associated headers and footers to grow or shrink depending on how many persons are listed vertically and how many "expertise" and "influence" items are involved. (The user organization will determine both of those things as part of the initial setup.) I have the necessary VBA worked out to "grow" the actual list of persons in columns A through E, but have been thinking for a couple days now about how to handle changing the width and length of the matrix itself. I've made copious use of range naming, and each square in the matrix contains a formula involving a custom VBA function, as do the colorized cells shown horizontally beneath the matrix. So there's a whole lot more involved than just inserting cells. Anyone who wants to opine on this challenge, or who can point me to a tutorial or whatever that might help me overcome my mental block, please chime in.

Capture.jpg

Well, here's the whole workbook then. Its purpose is to let an organization keep track of its Board of Directors: when they will reach the end of their term, and what skills each of them brings to the table. The starting point is the worksheet called "Lists," where the user initially sets up various things. For any given organization, the Board could have three members, or five, or fifty, and the skillsets (broken into Expertise and Influence categories) can also vary from a few to a lot. So the matrix, which is in the "Recruitment Forecast" worksheet, has to be re-sized as part of the initial setup, in both the horizontal and vertical dimensions, and if there are changes at some later point -- more or fewer board members or skillsets -- then the resizing needs to happen again. Given the complexity of the whole thing, though, that's not something most of the users will be able to handle, hence my need to fully automate it if possible. In essence, every time that report is opened I want the workbook to say "Is the matrix still sized correctly?," and if not, perform all the necessary steps to resize it. Hope that is sufficient explanation. This is still very much a work in progress, and this resizing thing is my next major hurdle.

Appears I've "stumped the band" on this one. No problem, I can do it all in VBA, was just hoping there's some magic feature built into Excel 2010 that I was unaware of that would be perfect for this situation.