I would like to use something like the fill handle in Excel to help
fill in a spreadsheet with hyperlinks. I want to link:

Sheet1 A1 to Sheet2 A1
Sheet1 A2 to Sheet2 A2
Sheet1 A3 to Sheet2 A3

....and so on. So far I have not had much luck. I can get it done one
cell at a time, but I would like to do about 1000 of them and there is
no way I am going to spend that much time on this. Does anyone know of
a way to do this automatically? Thanks in advance!

-Kevin