Thanks DBY, but i need to have a dropdown box because in the actual file it extracts data from another sheet. It doesn't need to be a hyperlink though - any other function that might be helpful? I will attach another workbook (and a new thread - not sure where to upload a file from here.............) Sorry and thanks for your help!