creating a master sheet that totals values from other sheets

[robert]

I'm hoping someone can point me in the right direction.

I'm trying to create a worksheet that totals values from other worksheets.


Specifically its a lineup sheet for little league baseball.
I'm trying to get the kids to all the positions in the field and the batting
order.

My lineup looks like innings across the top and players name up and down in
the
left column. I insert the position they play for each inning.

I would like my master sheet to have the players names follow up and down
and the positions across the top with how many innings they have played for
the data.


Hope this doesn't sound to convoluted.
I'm not sure where to start with this one.


thanks
robert

 

[Guest]

Hi Robert;

One way to accomplish it is to create all the sheets and
then make a master sheet. For each sheet go and copy the
information you want to appear then go to the master and
use the Paste Link method. You can get to this by
clicking on Edit / Paste Special and then using the Paste
Link option.

If you want the X & Y's of the information to change you
could also look at using a pivot table

Thanks,

Greg

 

[robert]

Thanks Greg

Pivot table works great

robert

Hi Robert;

One way to accomplish it is to create all the sheets and
then make a master sheet. For each sheet go and copy the
information you want to appear then go to the master and
use the Paste Link method. You can get to this by
clicking on Edit / Paste Special and then using the Paste
Link option.

If you want the X & Y's of the information to change you
could also look at using a pivot table

Thanks,

Greg