Use cell address text to determine paste destination

[jgaska]

Hello All.

I have been trying for two days to figure this out so I've finally come to ask for help. I have two spreadsheets, one with input information and one on which information will be output. On the input spreadsheet, it is set up so that, using the address function, I have a text string in cell A1 stating my desired output cell destination (i.e. $M$13). I would like to make a button that, when I click it, enters a formula (for the sake of this query, lets assume it will be "=2*2") in the desired cell (M13) on the output sheet. The button would be on the input sheet. Any help is greatly appreciated. Thank you.

 

[VoG]

Try like this with a button from the Controls toolbar (ActiveX control)

Private Sub CommandButton1_Click()
Sheets("Sheet2").Range(Range("A1").Value).Formula = "=2*2"
End Sub