While I'm familiar with OFFSET to define print ranges - I think I'm a bit stuck on how to adapt it or another method for what I'm attempting.

I have a report that I'm working on - lists personnel data down the left hand side and items across the top. Each person may have data for an item or not. The items can be categorized within unique groups. Brief example of a row of data below (real data may span 100's of columns thousands of rows), Items 1-3 would be group Alpha, 4-8 would be group Beta and Items 9 & 10 would be group Omega:

Person A | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Totals

This report goes to people who are not saavy with excel so I would like to make it so the data can be printed off by group with personnel data included. Due to the varying sizes of the groups - I'm not sure how I would make a dynamic print range that would print each group of respectively.

Or may I'm thinking of how to solve this the wrong way. I am limited with not being able to spread this across multiple worksheets.

Thanks in advance.