Forum Discussion

Britbiker2's avatar
Britbiker2
Copper Contributor
Jan 20, 2021

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

  • Britbiker2 

     

    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.

Resources