how to autmatically create and re name sheets from a list

Discuss the spreadsheet application
Post Reply
bouee
Posts: 5
Joined: Mon May 12, 2008 5:48 pm

how to autmatically create and re name sheets from a list

Post by bouee »

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 !
openoffice 2.4, windows xp home sp2
User avatar
Hagar Delest
Moderator
Posts: 32662
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: how to autmatically create and re name sheets from a list

Post by Hagar Delest »

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?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply