how to autmatically create and re name sheets from a list

Discuss the spreadsheet application

how to autmatically create and re name sheets from a list

Postby bouee » Mon May 12, 2008 6:16 pm

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
bouee
 
Posts: 5
Joined: Mon May 12, 2008 5:48 pm

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

Postby Hagar Delest » Tue May 20, 2008 2:08 pm

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?
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28951
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests