Forum Discussion
Britbiker2
Jan 20, 2021Copper Contributor
Inserting pages from another workbook
Hi
I often have test sheets to write for a large number of items (workbooks), that essentially are exactly the same in format. However two pages although the same in all work can not be written immediately.
Is there a way of writing them separately and automatically having them inserted into all the other work books without tedious copy and pasting?
1 Reply
You can inset a worksheet from another workbook.
Open both files, right click on the worksheet you want to insert into the other workbook -->Move or Copy --> from to book choose the workbook you wan to to insert the sheet, and check the box create a copy
* If my post helped you, please click on like.