F5F Stay Refreshed Software General Software Here is a simple, casual rewrite of your request:"I just need some help writing a script. Can you assist me?"

Here is a simple, casual rewrite of your request:"I just need some help writing a script. Can you assist me?"

Here is a simple, casual rewrite of your request:"I just need some help writing a script. Can you assist me?"

T
68
03-19-2026, 09:45 PM
#1
Here is what that script says: You are asking where the code starts counting. Also, if Google Sheets lets you make a copy for yourself even when it looks like no sheets are hidden, why does adding a new sheet always add "SHEET 10" instead of just continuing your original count? I want to know this so I can unlock my own stuff and build something similar.
T
thedarkjuggler
03-19-2026, 09:45 PM #1

Here is what that script says: You are asking where the code starts counting. Also, if Google Sheets lets you make a copy for yourself even when it looks like no sheets are hidden, why does adding a new sheet always add "SHEET 10" instead of just continuing your original count? I want to know this so I can unlock my own stuff and build something similar.

H
hdoor20
Senior Member
477
03-27-2026, 12:33 PM
#2
In Google Sheets, it comes back to show what's inside a specific cell using a row and a column number.
H
hdoor20
03-27-2026, 12:33 PM #2

In Google Sheets, it comes back to show what's inside a specific cell using a row and a column number.

E
eggman722
Member
176
03-28-2026, 12:07 PM
#3
In Google Sheets, this command finds something inside a specific cell by counting how many rows and columns you need to move away from the start. You can learn more at support.google.com/docs/answer/3098242?hl=en
E
eggman722
03-28-2026, 12:07 PM #3

In Google Sheets, this command finds something inside a specific cell by counting how many rows and columns you need to move away from the start. You can learn more at support.google.com/docs/answer/3098242?hl=en

R
riboulot
Member
56
03-28-2026, 01:13 PM
#4
It's actually much better than you might expect. Thanks so much that you didn't send me to watch a YouTube video instead of reading it directly! What are those invisible sheets for? How come there is a "sheet number #10" when there are only three total?
R
riboulot
03-28-2026, 01:13 PM #4

It's actually much better than you might expect. Thanks so much that you didn't send me to watch a YouTube video instead of reading it directly! What are those invisible sheets for? How come there is a "sheet number #10" when there are only three total?

D
DarkAndShadow
Junior Member
13
03-28-2026, 09:18 PM
#5
Watching YouTube clips is actually bad when you want something simple to do, and I don't know what that add sheet does at all.
D
DarkAndShadow
03-28-2026, 09:18 PM #5

Watching YouTube clips is actually bad when you want something simple to do, and I don't know what that add sheet does at all.

S
snowboard_123
Junior Member
2
03-30-2026, 01:49 AM
#6
S
snowboard_123
03-30-2026, 01:49 AM #6

S
seeker07
Senior Member
349
04-02-2026, 02:44 AM
#7
Why don't you make a fresh spreadsheet and put your own pages in there? Then whenever you add more rows, they will count up correctly.
S
seeker07
04-02-2026, 02:44 AM #7

Why don't you make a fresh spreadsheet and put your own pages in there? Then whenever you add more rows, they will count up correctly.

T
ThePonyQueen
Member
131
04-02-2026, 04:04 AM
#8
It matched exactly what the previous poster said. There aren't any hidden sheets, but if one got deleted, Google probably kept track of that. I was super curious because I thought there were secret scripts on other sheets, but I know Google can't pull data from a different workbook at least nobody has found out they do yet. I tried figuring it out back then, but adding the +1 in the formula messed me up! I haven't taken any courses, but I love learning how to figure things myself, which is why that first reply was so helpful! There WAS a hidden script with a sum! lol! BINGO! I thought that was super cool. Plus one extra feature on top of indexing and conditional formatting. I was stuck for hours until I found this forum after watching 2 videos there. Thanks so much! Totally bookmarking this site and waiting to learn more!
T
ThePonyQueen
04-02-2026, 04:04 AM #8

It matched exactly what the previous poster said. There aren't any hidden sheets, but if one got deleted, Google probably kept track of that. I was super curious because I thought there were secret scripts on other sheets, but I know Google can't pull data from a different workbook at least nobody has found out they do yet. I tried figuring it out back then, but adding the +1 in the formula messed me up! I haven't taken any courses, but I love learning how to figure things myself, which is why that first reply was so helpful! There WAS a hidden script with a sum! lol! BINGO! I thought that was super cool. Plus one extra feature on top of indexing and conditional formatting. I was stuck for hours until I found this forum after watching 2 videos there. Thanks so much! Totally bookmarking this site and waiting to learn more!

J
Jorben001
Junior Member
6
04-02-2026, 05:47 PM
#9
Like I mentioned, YouTube videos aren't great for something like this. If you have more questions, don't be shy about asking them. Lots of knowledge is waiting around here. Have a good time!
J
Jorben001
04-02-2026, 05:47 PM #9

Like I mentioned, YouTube videos aren't great for something like this. If you have more questions, don't be shy about asking them. Lots of knowledge is waiting around here. Have a good time!

L
LionSpear
Member
214
04-03-2026, 12:28 AM
#10
Thanks a lot!
L
LionSpear
04-03-2026, 12:28 AM #10

Thanks a lot!