Hello everbody,
I hope someone can help ! Here is what I would like to do in calc :
on one sheet a list of names, I'll call it sheet 1. On a second sheet, I'll call it sheet 2, a chart that would need to be adapted to each person in the list.
In order to do so, I would like Calc to copy sheet 2 , and create 1 sheet per name in sheet 1, and rename each sheet as per the list of names in sheet 1.
Is it possible, and if so how ??
Thank you very much for your help !
how to autmatically create and re name sheets from a list
how to autmatically create and re name sheets from a list
openoffice 2.4, windows xp home sp2
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: how to autmatically create and re name sheets from a list
Have you managed to do what you wanted?
According to your other thread ([Solved] How to automatically rename a sheet after a cell ?), it's almost done. You just have to create first the new sheets depending on the number of entries, right?
According to your other thread ([Solved] How to automatically rename a sheet after a cell ?), it's almost done. You just have to create first the new sheets depending on the number of entries, right?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10