"Dave Peterson" wrote:

I've always found it easier when all my data is on one location.

Yeah, if this was for me, I'd do it completely differently! ;) But I'm
setting it up for a friend who wants to have each show on its own sheet.
She'll also use a new workbook for each season.


I like to put my titles in row 2 and my subtotals in row 1 (so they're always
visible).

Excellent idea. Thank you. What I've done is put the running totals in
columns A to C and used the freeze panes function so as you scroll to the
right, you can still see them.

By having the data laid out like this, you can do some nice filtering and even
pivottables to get summaries (and group by month per show per category) (and
pretty charts, too!).

I've got another sheet that's a pivot table, but I've had to type "='Show
1'K8" (the cell where I've summed everything already) for each one. It does
it automatically, but took a bit of time to create. And yeah, got charts too
:)

Thanks for the links. I haven't used pivot tables much.