Google Sheets Automation With App Script | Split A Worksheet & Delete Worksheets

Опубликовано: 13 Август 2024
на канале: Jie Jenn
159
8

In this video, I want to share two automation scripts that can make your workflow in Google Sheets more efficient. For the first script, we'll look at how to split a worksheet into multiple sheets based on a selected column. For the second script, we will create a procedure to delete all worksheets except the active sheet. These scripts can save you a lot of time and effort, especially when managing large number of worksheet and datasets

Source Code:

Show Support
Paypal:
Venmo:
Patreon: (early access to tutorial source code)
️ Business Inquiring: YouTube

00:00 - Scripts Demo
01:51 - Script: onOpen Function
03:24 - Script: showColumnSelectionDialog Function
04:26 - Script: splitWorksheetBasedOnColumn Function
06:12 - Script: deleteAllExceptActiveSheet Function


Смотрите видео Google Sheets Automation With App Script | Split A Worksheet & Delete Worksheets онлайн без регистрации, длительностью 07 минут 49 секунд в хорошем hd качестве. Это видео добавил пользователь Jie Jenn 13 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 15 раз и оно понравилось людям.