linking pages of a workbook
 

I have a list of clients and client IDs that I type into page 1 (the front
tab). In each of the other pages of the workbook, I need to have the same
list of clients / IDs. I would like to link the list so that when I type in
a new client name / ID, change a client name etc. the corresponding pages all
update at the same time.

Let me give an example:
page 1 of my worksheet
column A has the client names (row 1- 106)
Column B has the Client ID (row 1-106

page 2:
Column A has the client names (starting on row 2 - row 1 is a heading)
Column B has the client ID (row 2-107)

If the client ID for John Jones (on page 1 column 2, row 17) changes, how
can I get page 2 to update as well?

linking pages of a workbook
 

On sheet #2 in the second row of the first column type in the cell:

=Sheet1!A1

Then again on sheet #2 In the second row of the second column type in the
cell:

=Sheet1!A2

Rob

"exel exhausted" wrote:

I have a list of clients and client IDs that I type into page 1 (the front
tab). In each of the other pages of the workbook, I need to have the same
list of clients / IDs. I would like to link the list so that when I type in
a new client name / ID, change a client name etc. the corresponding pages all
update at the same time.

Let me give an example:
page 1 of my worksheet
column A has the client names (row 1- 106)
Column B has the Client ID (row 1-106

page 2:
Column A has the client names (starting on row 2 - row 1 is a heading)
Column B has the client ID (row 2-107)

If the client ID for John Jones (on page 1 column 2, row 17) changes, how
can I get page 2 to update as well?