I have made one sheet, a bingo card and wanted to copy it about 400 times. Is there an easy way to do this?
I have been doing it one by one and it is taking ages!
Creating the 400 sheets with right-click on sheet tab, select insert sheet and do accordingly.
Go to sheet to copy, select all [Ctrl+A]
Copy [Ctrl+C]
Select all other sheets by clicking the tab of first where copy, while keeping the [Shift] key pushed click on the tab of the last sheet, so they are selected.
Paste [Ctrl+V]
If the answer solves your question please tick the .
In one way it did work… But in another it didn’t
It has now changed all of the inputs from stuff like;
=IF(ISERROR(VLOOKUP(A1,$List.A5:E49,2,0)),"",VLOOKUP(A1,$List.A5:E49,2,0))
to
=IF(ISERROR(VLOOKUP(A1,$#REF!.A5:E49,2,0)),"",VLOOKUP(A1,$#REF!.A5:E49,2,0))
So the values I have in a list will not be automatically inputted into their locations (there’s lite 30 of these Look ups on each sheet)
What version of LIbreOffice?
Version 5.0