I have information stored in a Google Sheets document, which I’ll refer to as sheetA. I want to pull that information into another document, labeled as sheetB. For instance, I am looking for a way to use a formula like =sheetA!Tab1!B3. What steps should I take to achieve this? I am open to adjusting security settings if necessary.
You might wanna use the IMPORTRANGE formula, super handy for this! Just make sure you share sheetA properly with the account using SheetB otherwise it’ll run into access probs. First, authorize the connection by importing any random cell, then you can specify the exact range you need.