Jan 20 2021 10:16 AM
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?
Jan 20 2021 10:30 AM
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.