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
