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