View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] grahambae@gmail.com is offline
external usenet poster
 
Posts: 5
Default Referencing a Range of Sheets

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