Create Excel sheets from a list
Solved
i7
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello,
here it is: I have a list in an Excel sheet (column A), with n items.
I would like to be able to go through my list and create as many sheets as there are elements in this list. Furthermore, I would like each created sheet to be named after the corresponding element in the list.
On another note, if I may ask, I would also like to know how I can ensure that if I add or remove an element from the list, I can update my set of sheets (in short, that new ones are created and some can be deleted).
Thank you for your help.
here it is: I have a list in an Excel sheet (column A), with n items.
I would like to be able to go through my list and create as many sheets as there are elements in this list. Furthermore, I would like each created sheet to be named after the corresponding element in the list.
On another note, if I may ask, I would also like to know how I can ensure that if I add or remove an element from the list, I can update my set of sheets (in short, that new ones are created and some can be deleted).
Thank you for your help.
Configuration: Windows XP Firefox 2.0.0.15
3 réponses
Good evening,
To create a new sheet, you just need to right-click on the tabs at the bottom left that are named by default sheet 1, 2, etc., and name them as you wish. Then you need to copy and paste the elements you want into each sheet. For updates, it's a bit trickier; you need to create references between each sheet and the main one.
To create a new sheet, you just need to right-click on the tabs at the bottom left that are named by default sheet 1, 2, etc., and name them as you wish. Then you need to copy and paste the elements you want into each sheet. For updates, it's a bit trickier; you need to create references between each sheet and the main one.
Actually, I would like to be lazy, and therefore create a macro that would create my sheets for me. Like, if I have 250 names in my list, just doing a quick CTRL A instead of 250 right-clicks and typing my 250 sheet names.
If you know how to create this macro...