Import RESTRICTED data from Google Sheets Part 2/2

[@pinkygamit9139]

Sir, how can import multiple sheets data... In excel ...please

[@ExcelMacroMania]

You need to target each sheet with the respective gid. The URL for the Google spreadsheet looks as follows, and the gid is specific of each sheet.
docs.google.com/spreadsheets/d/1WopmB1ExWSNul9sw9n7I9FEyquS4AyEugt_fKQrHJSI/view#gid=2009384141

[@SndOfMzk]

Hello and thank you for the method explanation. How to import data to a specific range on a specific worksheet? And another question: is it possible to export data in the reverse direction from excel table to a restricted google sheet via the same method?

[@ExcelMacroMania]

Check this other video to see how to import specific cells from specific sheet too. The sheet of a Google spreadsheet has a unique gid parameter in the URL.
ruclips.net/video/c841qBQAhUM/видео.htmlsi=hLjtVQKfviWRsJem
To export data from Excel to Google Sheets (via Google Form) check this other video:
ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=CSYoTUl6OKjdmbFq

[@alvinxunjieang7356]

How do I call the data to specific worksheet and cells?

[@ExcelMacroMania]

That's explained in this other video: ruclips.net/video/c841qBQAhUM/видео.htmlsi=sRrkpMiGkibYNbEv

[@rochmadgrendhasonmaratno2365]

how to export data from excel to Google Sheets using VBA macros?

[@ExcelMacroMania]

That's covered in this other video: Export Data To Google Sheets: ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=rgIT3fSjxUqJlLmO

[@profoundveda3584]

How to import data from restricted google sheet without access

[@ExcelMacroMania]

You cannot import data if you don't have access to the restricted google spreadsheet.