Correct Excel Formula

Status: Closed
Prize: $15
Entries Received: 5
Winner: redeyedmars1

Winner

Contest Brief

Fix Excel function: =HYPERLINK("#Social!A" & "5",
"Socail Media Promotion"). The Hyperlink function references a worksheet: Social" in the same work book: #. The problem is that the hyperlink goes to the same cell location "A5" using static reference, when copied and pasted. I need the Hyperlink to reference the relative cell in the A column when copied and pasted.