linking pages of a workbook

E

exel exhausted

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?
 
R

RobM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top