I run a Hockey League website and input stats using excel. I have a
spreadsheet for each team (one for players and one for goalies) plus
league stats as well. I have been adding the data in each sheet
seperatly but know there is a way to just enter them once. Can someone
walk me through this? The website is www.smbghl.com if you want to take
a look and see what I'm talking about.

Thanks


--
The Smuffer
------------------------------------------------------------------------
The Smuffer's Profile: http://www.excelforum.com/member.php...o&userid=32138
View this thread: http://www.excelforum.com/showthread...hreadid=518917

Hi The Smuffer,
Two simple examples a

Example1.
Say you want whatever you type into A1 on Sheet 1 to also appear in B1
on Sheet 2, then..
1) Click on B1 on Sheet 2 then type an equals sign. DON'T hit Enter.
2) Click on the Sheet 1 tab (towards the bottom of the screen).
3) Click on A1 on Sheet 1.
4) Now hit Enter. Excel should automatically jump back to Sheet 2 and
you will see a zero in B1.
5) If you don't want a zero when A1 on Sheet 1 is empty then you will
have to change the formula that you see in the formula bar when Sheet 2
B1 is selected. That formula at the moment is =Sheet1!A1 ( or 'Sheet
Name'!A1 if your first sheet has a two word name eg 'All Saints'!A1).
Change the formula to = IF(Sheet1!A1 = "","",Sheet1!A1)

Now, when Sheet1 A1 is blank so is Sheet B1 and what ever you type into
Sheet 1 A1 will automatically appear in Sheet B1.

Example 2.
Say you want what ever you type into Sheet 1 A1 to appear in Sheet 2
B1, Sheet 3 B1 and Sheet 4 B1 then...
1) Click on the Sheet 2's sheet tab.
2) Hold down the Shift key while you then click on Sheet 4's sheet tab.
This groups together Sheets 2, 3 and 4.
3) Repeat steps 1) to 5) of Example 1.

If you want different cells in multiple sheets to be linked to the same
cell on sheet 1 then they will all have to be done separately. However,
if you want say B1:B20 in one sheet (or a group of sheets) to be linked
to the same number of column cells on another sheet then you only have
to follow the above steps for the top cell, then fill down to copy the
linking formula to all the other cells in the column.

Hope this helps.

Ken [Henry VIII:-)] Johnson

Hope this helps.

Ken [Henry VIII:-)] Johnson


LOL! I thought you Tudors had died out?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

Hi Peo,
It's nice to know someone out there appreciates my humour!
Ken Johnson

Thanks for the help, that was pretty simple. I created a master player
worksheet with all the players from my league. I also created seperate
team worksheets for all my teams. I now have them linked together.

My next question is: If I need to add a new player is there a way to
only add him once on the master and have it automaticly show up on the
team sheet, or visa versa?


--
The Smuffer
------------------------------------------------------------------------
The Smuffer's Profile: http://www.excelforum.com/member.php...o&userid=32138
View this thread: http://www.excelforum.com/showthread...hreadid=518917

Hi Smuffer,
If the new player is an extra player, not a replacement for a departing
player, the team sheet could have a linking formula in the next vacant
cell of the team's list of player names. This linking formula should
link that cell to the cell on the master sheet where you will be
entering the new player's name. So it's just a matter of having extra
linked cells on your team sheets linked back to empty cells on your
master sheet. If you are using the IF version of the linking formula
then these extra linked cells on your team sheets will just show up as
blank cells until you add a new player's name to the master sheet.

I hope this makes sense.

Ken Johnson