Ask Your Question
0

Can I copy 1 calc sheet multiple times in one go?

asked 2017-07-19 21:38:59 +0100

Paul82 gravatar image

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-07-19 22:38:22 +0100

m.a.riosv gravatar image

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]

edit flag offensive delete link more

Comments

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-07-19 22:55:54 +0100 )edit

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)

Paul82 gravatar imagePaul82 ( 2017-07-19 23:19:49 +0100 )edit

What version of LIbreOffice?

m.a.riosv gravatar imagem.a.riosv ( 2017-07-20 10:46:42 +0100 )edit

Version 5.0

Paul82 gravatar imagePaul82 ( 2017-07-20 19:07:26 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-19 21:38:59 +0100

Seen: 47 times

Last updated: Jul 19