LinkBack URL
About LinkBacks
Hey all, is there a way to automatically create multiple named sheets at the same time, rather than to manually doing it? I have the names of all my sheets in a column of cells and I was wondering if I could use that somehow. Thanks.
Hey all, is there a way to automatically create multiple named sheets at the same time, rather than to manually doing it? I have the names of all my sheets in a column of cells and I was wondering if I could use that somehow. Thanks.
Yes, it can be done. Can you give us some more info?
In which column are the sheet names? Do you want to make a copy of a template and rename it as per the list or do you want to insert blank sheets and name them?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The sheets are in column A downwards and I want the new sheets to be created from scratch, and named as each of the items.
Try...
Please Login or Register to view this content.
HTH
Regards, Jeff
Awesome, that solved it thanks. Just a followup, though. Is there a way for me to put other information into each sheet as well during the same process? like, let's say copy pasting the entire format of one sheet and duplicating it with each new sheet made.
Of course this is possible and that is why Arlette asked if you wanted to make a template and copy it or blank sheets.
Give me a few minutes...
Try this...
Create a sheet called Template and make this sheet the way you want all sheets to be...
On Sheet1 column A is where the list of sheet names is stored...
Please Login or Register to view this content.
Thanks! That's awesome! :D
You are very welcome. Glad it worked out for you and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks