An Excel question

[gridlore]

I've done an Excel spreadsheet so we can track kshandra's revenue at Stupid Shuttle. I've taught it all sorts of tricks, like figuring how much she's making an hour, weekly and monthly totals and the like, but there's one thing I can't figure out.

I have the book separated into worksheets for each month, with a year end sheet. I'd like to be able to link the monthly total cells in each month with the correct cell on the year end page. For example, if Kiri made $250 in credit card tips in August, I'd like that information zap from the cell on the August page to the August section on the total page.

Any body know how to do this?

Comments

[karmabreeze.livejournal.com]

Try the pivot table wizard...? I know just enough about Excel to really mess everything up.