Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm making a spreadsheet to keep track of some of my soccer team's
statistics throughout the season. I'd like to present all the data on the first worksheet, and I plan to make a new sheet for every match that we play. What I need is for cells on the first sheet to reference the data from the cells on a range of sheets. My main requirement is along these lines: I need cell Squad!C2 to add up and present the values cells Match1!C2 and Match2!C2 and Match3!C2 etc. I hope that makes sense, because once I have that solution the rest of the spreadsheet follows along the same lines. I don't have anywhere to upload the excel file, but I'd gladly e-mail it to anyone who's willing to help. Thanks in advance, Graham Bae |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Issues referencing range between workbooks | Excel Discussion (Misc queries) | |||
Referencing other sheets - updates | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Formulas referencing other sheets | Excel Discussion (Misc queries) | |||
range of data from different sheets | Charts and Charting in Excel |