Jul. 26th, 2003
An Excel question
Jul. 26th, 2003 10:44 amI'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?
![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
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?