Can I copy/paste a sheet from book B into a Book A where the imported Sheets fro

ID: 643022 • Letter: C

Question

Can I copy/paste a sheet from book B into a Book A where the imported Sheets from book B now refer to the other sheets/cells from Book A?

I have some comprehensive company workbook templates i have to fill out for all clients

Some sheets are quite repetitive

I am wondering whether i can copy/paste sheets from existing books into my new client book

The problem being these sheets make reference to other sheets (client data) in the book

Can I copy/paste a sheet from book B into a Book A where the imported Sheets from book B now refer to the other sheets/cells from Book A??

Thanks !!

Hi..

If the referenced locations in Book B are the same (sheet name and cell address) as you want in Book A, you can do it.

Copy the sheets or the data and then use
Data > Edit Links > select the entry for Book B > Change Source;

and browse to select Book A and click OK;

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.