LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues referencing range between workbooks Rob Manger Excel Discussion (Misc queries) 3 August 16th 06 01:10 AM
Referencing other sheets - updates shakey1181 Excel Discussion (Misc queries) 7 July 24th 06 01:59 AM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
Formulas referencing other sheets eel77 Excel Discussion (Misc queries) 4 July 18th 05 07:34 AM
range of data from different sheets SteW Charts and Charting in Excel 2 June 26th 05 07:31 PM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"