I am new to Google Sheets, Apps Scripts and JavaScript so kindly bare with me.
I am particularly interested in Google Sheets due to its ability to control user access to specific ranges for data entry purposes.
I have information that I would like split across different sheets in a spreadsheet. As there is a lot of information with details that can be categorized, I am planning to separate the information across different sheets/tabs per category for ease of use.
Due to the expected large number of rows, I wanted to be able to synchronously scroll across these category sheets also for ease of use. I managed to do the same using Macros on Excel, please see this excel file to have an idea of what I am intending to do.
Basically when a cell (or even row) is selected in the active category sheets, the same row is selected in all the other inactive category sheets. Alternatively, when the user selects a category sheet, it should check which row is selected in the previously selected category sheet and select the same row in the newly active sheet.
I was playing with Apps Script but wasn't able to set the selection of an inactive sheet. Similarly, when selecting another category sheet, I was unable to get the selected range from the previously selected category sheet - getSelection() and getActiveRange() always return selection of the current active sheet.
Is there any way I can achieve this? Are there alternative solutions anyone can suggest to reach a similar target? For example I was also looking at the sidebar but that reduces the number of columns viewable ... wanted to minimize horizontal scrolling as that is the main intention of splitting the data between sheets to begin with.
I will greatly appreciate any feedback.
Thanks in advance.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…