Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking worksheet pages | Links and Linking in Excel | |||
Excel 2002 : Any faster way for linking formulas between pages ? | Excel Discussion (Misc queries) | |||
linking excel pages | Excel Discussion (Misc queries) | |||
Linking a column on One worksheet to Multiple Pages in Another Doc | Excel Discussion (Misc queries) | |||
Linking multiple pages | Excel Discussion (Misc queries) |