What formula do I use for copying cell information between workboo

[Darren]

To explain my predicament: I am the manager of a football team. I have 2
workbooks, one for player appearances, the other for player goals. On the
'players goals' workbook, I have the position the player is in our all-time
goals list, their name, number of goals scored, I have created a 'goal
percentage' column, and finally, I have a column for their appearances. A
simple calculation to divide the number of goals by the number of appearances
works out the goal percentage.

What I am trying to do is to copy over the information on the Appearances
workbook for individual players into the Appearance column on the goalscorers
workbook. I know how to copy over one cell to another between workbooks but
my problem is that whenever a person's position on the Appearances workbook
changes, ie because they have made more appearances, if I move that person up
a place, the formula on the goalscorers workbook for their appearances
doesn't move with it. Any ideas?

 

[Bernard Liengme]

You need to look in Help under VLOOKUP
Have you considered having only 1 workbook but using multiple worksheets.
Otherwise, VLOOKUP will require you to open the second file
best wishes

 

[Darren]

Hi

I'm not sure that this is the way to proceed. Can anyone else help me. To
explain clearly:

Workbook 1 is called 'top appearances' and has 3 columns. the left hand
column (A2) has a number from 1 to (curently) 165 where 1 represents the
column (A3)where the person who has had the most appearances sits with the
column (A4) represents the number of appearances. Clearly as players play
more games, they move further up the figures.

Workbook 2 is called 'top goalscorers' and has 4 columns. the left hand
column again remains fixed, representing the position of the relative
goalscorers, column 2 has the players name, column 3 has the number of goals
scored for the club, and column 4 has the goal percentage based on games
played whilst column 5 has the number of appearances each player has had.

Because i have 2 spreadsheet, i need to know the easy way to ensure the 'top
appearances' data is kept up to date. Short of speaking with my second team
manager, i don't know the answer! help help help