Linking cell question
 

Is it possible to link a cell to a workbook by typing in a specific value in
a cell?
Let me see if I can clarify that. In a master workbook I have a column with
municipality codes. If I type in code 301 and fill in the rest of the info
pertaining to that code in that row, can I have that automatically link to a
workbook named Muni301 and update that with the same info? So basically it's
linking off of the number 301. Thanks for your help. Terry

Linking cell question
 

make your cell a hyperlink
--
paul

remove nospam for email addy!



"TBoe" wrote:

Is it possible to link a cell to a workbook by typing in a specific value in
a cell?
Let me see if I can clarify that. In a master workbook I have a column with
municipality codes. If I type in code 301 and fill in the rest of the info
pertaining to that code in that row, can I have that automatically link to a
workbook named Muni301 and update that with the same info? So basically it's
linking off of the number 301. Thanks for your help. Terry