Google Sheets IMPORTRANGE: Prevent clever editors from accessing other ranges of your imported sheet
Link to the written tutorial & the starter Google Sheet here: https://wp.me/p9ksIb-6Zf
If you think IMPORTRANGE will hide data from your source sheet, you're mistaken. Find out how to fix this here.
00:00 Intro
00:28 Proof that you can access other ranges in the imported sheet.
02:22 Solution 1 - Sheet Tabs
03:05 Solution 2 - Hide the formula
06:35 Solution 3 - Intermediary step
Like and subscribe to find out when the next tutorial on how to import specific data with QUERY, FILTER and VLOOKUP.
IMPORTRANGE using Google Apps Script: • Copy and Paste Range Values from one ...
If you like the video, check out my website:
https://yagisanatode.com/
Here is the link to just Google Sheets tutorials:
https://yagisanatode.com/google-sheets/
Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
https://yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
https://www.zazzle.com.au/collections...
#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace
Watch video Google Sheets IMPORTRANGE: Prevent clever editors from accessing other ranges of your imported sheet online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 01 February 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 2,393 times and liked it 36 visitors.
