Hyperlink to another workbook

Please Help! I want to create a hyperlink to another workbook and need to drag and drop it just so i get same column values & links the same time.
i dont want to hyperlink every cell in a column manually.

Thank You. :)