spoogehead
New Member
- Joined
- Sep 15, 2002
- Messages
- 31
I want to link every occurrance of a name to a corresponding value which is updated every so often. For example:
Jones 2
Bloggs 1
Jones 1
Smith 4
Brown 6
Jones 10
(Apologies, i couldn't get Colo's utility to work). The numbers are in different cells. I want the corresponding numbers for ALL occurrances of Jones to change to whatever value I put in the first "Jones" cell. So if i change the first "Jones" cell to 5, I want all the other "Jones" cells to automatically change to 5. Can this be done. Thanks in advance
Jones 2
Bloggs 1
Jones 1
Smith 4
Brown 6
Jones 10
(Apologies, i couldn't get Colo's utility to work). The numbers are in different cells. I want the corresponding numbers for ALL occurrances of Jones to change to whatever value I put in the first "Jones" cell. So if i change the first "Jones" cell to 5, I want all the other "Jones" cells to automatically change to 5. Can this be done. Thanks in advance