Creating multiple worksheets from one worksheet
Hello all,
I have a template worksheet with vba codes assigned to it.
What I need is:
I need a button in the template sheet as "Copy".
When clicking the button it should prompt me a InputBox.
So that the value I enter should become the name of the sheet created.
Will I get a worksheet with vba codes assigned to it or only the Worksheet with formulas?
File attached. Kindly consider the template worksheet.
Kinldy please help me out.
Thanks in advance excel gurus.
What if the sheet name you put in the inputbox already exists? What do you want to do in this case?
What do you mean by this?Will I get a worksheet with vba codes assigned to it or only the Worksheet with formulas?
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]
Hello Admin,
If the worksheet with the name already exists then a msgbox should be popped up and indicate us by" Sheet already exists & sheet not created".
I have assigned VBA codes to the Template.
So will also the VBA codes be copied to the created sheet?
If a move/copy is done to the sheet directly, the codes will also get copied.
In this case then, the contents and formats of the template will need to be copied. Its good you asked this question, if we had not known it, every sheet would have had the code that the template has.
Ok Admin.
How to achieve this?
Do you want the codes to be copied as well or only the template?
Yes Admin I need the code also to be copied.
Is it possible?
Yes its possible. We just have to make a copy of the sheet.
Ok Admin.
Can you provide the code for that?
Is this thread similar to this one - http://www.excelforum.com/excel-prog...one-sheet.html - here also sheets need to be created based on the template and same sample file.
Yes Admin.
I didn't get any replies so only posted this new thread.
Also our forum daily gets too many threads so it goes back to many pages.
Its against the forum rules to create duplicate threads. Even if the forum gets hundreds of threads, you can bump your thread or push your thread up the list by putting in text such as "Need help please".
Sorry for the duplicate post admin.
As am new so didn't know these rules.
You can close the thread.
That Column E is my actual requirement admin.
I used to enter the participant details in the sheet.
Once the button is clicked it should create sheets with the datas from the template sheet.
Please solve my problem.
So you do not require the message box option at all?
Hello Admin,
I don't need the input box at all.
It should create the worksheets based on the cell value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks