How to Create button Go to specific sheet in Google Spreadsheet

In this video, I will show you, How to Create a button Go to a specific sheet in Google Spreadsheet.
** Premium Service **
bit.ly/2TiFH5l
bit.ly/2NaJtY9
bit.ly/2IezzWG
Facebook Page:
goo.gl/mVvmvA
goo.gl/FmZ84U
Please Subscribe My Channel:
goo.gl/9kkcty
Button Script: bit.ly/30kAJ8V
#sheet_button #go_to_sheet_button #iLink_sheet_button

[@ABHISHEKGUPTA-yi3vu]

Just what i wanted !!!
Thanks :)

[@PDFEditing]

Glad to hear that!

[@nywanderer100]

Thank you. "Just what the doctor ordered," as they say. Cheers.

[@user-qu1zu7ji6s]

i was looking for it!!!!!

[@mikepuno2000]

I really want to thank you for sharing your wonderful ideas on this, it is very useful for my project, again a big thanks.

[@TeacherGunar]

Thank you very much for the script. It helps me a lot.

[@PDFEditing]

Glad to hear that

[@newera2853]

it was really helpful. thank you

[@PDFEditing]

Glad it helped!

[@hassanmburia8825]

Thank you so much GOD bless

[@PDFEditing]

You are so welcome

[@averagedudeusa9722]

its crazy how the developers dont know how to make the process more simple. This is too much trouble to go through for a basic button. either way excellent explanation. thanks.

[@astropgn]

It might look like it is a lot of trouble, but this is actually quite powerful. Anyone can follow this 5 min video, and you can then use this knowledge to build more complex systems.

[@user-gm3ux6kt8i]

its very helpful, thanks

[@PDFEditing]

You're welcome!

[@rufiorufio4693]

thank you for this.

[@PDFEditing]

You're very welcome!

[@ailenesanjuan5595]

Thanks for this! Is there a way that one button can open multiple sheets not just one?

[@PDFEditing]

Not that I know of

[@bambangpurnamasomalinggi319]

tks alot brother....i am from manokwari papua

[@PDFEditing]

Welcome 👍

[@mohanadhazah6311]

Great Job

[@PDFEditing]

thank you

[@andrewbray1570]

Very Helpful - but I couldnt' get a copy of coding you display. That would be very handy for all.

[@PDFEditing]

thank you

[@TheBtrivedi]

Thank you.

[@PDFEditing]

You're welcome!

[@ammararafique6225]

ThankYou Mate

[@PDFEditing]

You're welcome!

[@user-wo5rw5lo1s]

Thank you

[@PDFEditing]

welcome

[@canyasin16]

Thanks

[@PDFEditing]

Welcome

[@biruareva]

function P1() {
// 1 = row 1, 14 = column 14 = N
goToSheet("DashBoard",47,1)
}
function goToSheet(sheetName, row, col) {
var sheet= SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row,col)
SpreadsheetApp.setActiveRange(range);
}

[@rahmatollohoktyabirov7287]

Here you are assigning to the fixed page, but I want to give the reference to the specific cell. How can I do that? For instance, I have 100 pages, I will put list of pages to the cell A1, (it will be drop down list) after that if you click the button it will take you to the page that is shown on A1 cell ?

[@ammararafique6225]

Thanks Mate

[@lorvha]

how can i a button for "Go to specific Ceell"? Example Cell: G1:L1
Thank you very much for answer

[@EdgeOfYesterday]

Hi Lorvha. This is a late reply hope it is still useful. This script will open a dialogue box and ask for the cell reference you enter it and then click OK
function goToCell()
{
var strRange = Browser.inputBox("Insert the required cell (e.g.: B20):", Browser.Buttons.OK_CANCEL);
SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
}

[@jesusdelavega7101]

@@EdgeOfYesterday it's not working

[@walidtawk2828]

hello thank you for this video, but it is giving me an error (scripts cannot convert 'comments' to int.)

[@willsgrandad]

I wanted to get to any sheet. Used Insert...Link...Sheets and named ranges... selected sheet I wanted .. enter.
You get a cell with the sheet you want to go to. Click on cell and choose cell name . done.
No scripts
No Drawing buttons
However you do not get a button displayed, just a cell.
Hope this helps someone

[@paleteriaelpibe7035]

Greaet idea. Do you know how to make it clickable?

[@rodrigonobrega7777]

Excellent idea! Thanks for sharing!

[@rodrigonobrega7777]

@@paleteriaelpibe7035 Good question. It's clickable, but needs 2 clicks (one on the cell, another on the link that appears nearby). Maybe not so straightforward for users of our sheets, but helpful anyway.

[@sovannaryhong1610]

My tool doesn't have script editor function, what can I fix that?

[@astropgn]

Google changed its location, it is on "Extensions -> Apps Script" now.

[@Video_Populer]

if it is made like that, can the hidden sheet be accessed?

[@PDFEditing]

no

[@SewModernBags]

I am getting this message when I click the button A script attached to this document needs your permission to run. And its asking me to sign into the account I'm already signed into.

[@astropgn]

It is normal. You are not signing in into your account, you are authenticating that you trust the script you just created. After trusting it and giving it permission to run on this spreadsheet, it won't prompt this anymore.

[@mikeshedrack1381]

Nice job...no need of repeating the functions(gotosheet function), one function will serve all the buttons😂😂
Just call it and assign thr parameters

[@PDFEditing]

Thanks for the tips!

[@micadistribuidora6951]

como se puede hacer un boton para imprimir en google sheets

[@TemplesOfIndia_explore]

Hey please help me out my script is running but not able to go to particular sheet

[@PDFEditing]

use my script

[@lukeanderson4593]

"Exception: Invalid argument: sheet"

[@prodSpTcher]

GOOD job
but dosent work on mobile (androïde & ios)

[@anowarhossan4985]

Button Script link not working

[@bilguunjargalsaikhan5030]

Please share the code.

[@ajaykasani1120]

CAN WE CREATE PRINT BUTTON ?

[@shubhamsharma8373]

I want to send mail according to the customer mail ID not specific mail ID so how we add mail ID cell in script

[@shubhamsharma8373]

I want to send mail according to customer mail ID

[@rokkirocks4016]

Not working bro....

[@PDFEditing]

what happened there?