I need help with a formula to update a cell using the row and column number contained in separate cells.
The VBA would look like this...
I just can't seem to do this in a formula
Thanks
Jim
The VBA would look like this...
Code:
Sub Macro1()
'
' Macro1 Macro
mrow = Range("q1").Value ' the cell which contains the row number for the data
mcol = Range("p1").Value 'the cell which contains the column number for the data
Range("a1") = Cells(mrow, mcol).Value ' the destination
End Sub
I just can't seem to do this in a formula
Thanks
Jim