Hyperlink

Hi,

how do i manually create a hyperlink?

i know i can select the cell and then insert hyperlink (CTRL+K) and then select the sheet/cell i want it to go to but...

i have to do this for 200 rows on 2 different sheets.
i want to be able say to Sheet1 A1 Link to Sheet2 A1 then Sheet1 A2 Link to Sheet3 A1 so the only thing i need to change is the sheet number... not the cell.

is there a formula that i can drag down to do this or somthing else?

Regards,
Jamie

Thats works perfectly but what i didn't know is that when i do the following it loses the hyperlink

HTML Code: 

You can probably tell but this basically makes that cell = whatever is displayed in another workbook.

When i put that in it then loses the hyperlink... is there anyway of putting the 2 codes together?

i have got 2 workbooks (lets say book1 and book2)
book2 copies pretty much everything in book1

for eample book2, sheet1, a1 = book1, sheet1, a1
i also need book2, sheet1, a1 to link to book2, sheet2, a1

so book2 needs to not only = book1 but the same cell needs to hyperlink to another sheet, hope that makes sense

i didnt realise that after putting

HTML Code: 

in it would lose the link, i knew the text would change but i thought the link would have be retained?

Regards,
Jamie