ok can anyone help me with this? Aaron has posed some great code above with the macro below to run the formula

Sub MyTest()
MyCon [B2:B3], [E3], 10, 1
    MyCon [B2], [E6], 10, 2
    MyCon [B2], [E7], 10, 3
    MyCon [B6], [E2], 4, 4
    MyCon [B6], [E8], 4, 5
End Sub
Im still trying to sort my associates but im gonna have to break it down one stage at a time or im never gonna figure this one out

can anyone tell me how to set this test macro up so i can ref a start cell from an input box and a finish cell from an input box and then press a button to establish a link on a new sheet?