excel : no vba : referance or link cell to a remote server data with variable -

excel : no vba : referance or link cell to a remote server data with variable -

i have cell referanced remote server formula:

=serv~10~0'!'23'*1

10 should variable referanced cell in same sheet

i tried didn't work

=indirect("serv~" & $a$1 & "~0'!'23'*1")

any thought how it!!

1 vba solution:

private sub listbox1_click() application.screenupdating = false dim cmpcd string cmpcd = cstr(cells(1, 1).value) 'field title = company name cells(2, 3).formular1c1 = "=serv~" & cmpcd & "~0'!'23'*1" application.screenupdating = true end sub

excel excel-formula remote-server excel-indirect