So, I have two workbooks, one with multiple sheets(W1) and one empty(W2) I want the empty one (W2) to have all the data (all strings, chars, and SHEETS) that (W1) has.

IMPORTRANGE only takes data from a single sheet of a workbook, and I am not interested in that.


There is no way to "reference" a whole workbook into another by using built-in formulas or custom functions, the alternative is to use Google Apps Script, the Sheets API or an Add-on to copy the sheets and values from one workbook to the other.

Built-in and custom functions only are able to return values, they can't create sheets and cant't modify spreadsheets, sheets and cell settings/properties.


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.