Get values from other sheet in Google sheets

[Joni_Depp]

I want to get values from other sheets.

I have some values in google sheet (sheet2) for example:

I want to return or retrive the values back on sheet 1 based on the row number on sheet 2

I use a code in excel which goes like this:

Sub reviewRow()
Application.ScreenUpdating = False
Results = MsgBox("Do you want to View selected row?", vbYesNo, "")
If Results = vbYes And Range("C10") > 1 Then
i = Range("C10") //this is where i put the row number that i want to retrieve or review that can be changed as needed
Worksheets("Sheet1").Range("C6") = Worksheets("Sheet2").Range("C" & i) //sheet names can be changed as necessary
End if
Application.ScreenUpdating = True
End Sub

Is there a way to perform the same process in google sheets? Your help and insights will be appreciated.

 

[Rijnsent]

Hi Joni,
Why would you want to use VBA/code for that? You could also just use formulas, try e.g. the OFFSET formula with C10 as rows variable. But if you want to go into Google sheets and know a bit of VBA, Bruce McPerson has a great site: From VBA to Google Apps Script Archives - Desktop liberation
Cheers,
Koen