I am working on a spreadsheet and want to create a hyperlink automatically based on a couple things
1. "http://support.microsoft.com/kb/ " is the site I want to go to...
2. I want to link it to a kb article number in a specific cell

here's what I have so far.
=HYPERLINK("http://support.microsoft.com/kb/,c12","Download")

while this is correct and works.. it won't create the next cell number (in this case c12), I want it to automatically create the next when I copy and paste.
so it even though I copy =HYPERLINK("http://support.microsoft.com/kb/,c12","Download")
I want the next one to be =HYPERLINK("http://support.microsoft.com/kb/,c13","Download")
and after that it should be =HYPERLINK("http://support.microsoft.com/kb/,c14","Download")
and so on..