| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new worksheet based on and input box
I am hoping someone can help me out. I would like to create a macro to
achieve the following but not sure how to go about it: Create a command button which will create an input box which asks the user to type in a new job number (these are layed out as 12-3456), then the master job sheet (call it Master Job) is copied and the tab is named with the job number typed into the input box. Many thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a new worksheet based on and input box
Sub InsertSheet()
Dim strSheetName as String strSheetName = InputBox("Enter Job Number") Sheets("Master Job").Copy After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = strSheetName End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: I am hoping someone can help me out. I would like to create a macro to achieve the following but not sure how to go about it: Create a command button which will create an input box which asks the user to type in a new job number (these are layed out as 12-3456), then the master job sheet (call it Master Job) is copied and the tab is named with the job number typed into the input box. Many thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a new worksheet based on and input box
Thank you so much, it works perfectly.
"Jacob Skaria" wrote: Sub InsertSheet() Dim strSheetName as String strSheetName = InputBox("Enter Job Number") Sheets("Master Job").Copy After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = strSheetName End Sub If this post helps click Yes --------------- Jacob Skaria "Mustang" wrote: I am hoping someone can help me out. I would like to create a macro to achieve the following but not sure how to go about it: Create a command button which will create an input box which asks the user to type in a new job number (these are layed out as 12-3456), then the master job sheet (call it Master Job) is copied and the tab is named with the job number typed into the input box. Many thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a new worksheet based on and input box
Hello,
I have a problem like this. Except i want to be able to create a new sheet that will contain new data but increment certain data eg day 1 day 2 etc. I also need to be able to continue calculations. Any help would be appriciated (sp?) thanks. "Mustang" wrote: I am hoping someone can help me out. I would like to create a macro to achieve the following but not sure how to go about it: Create a command button which will create an input box which asks the user to type in a new job number (these are layed out as 12-3456), then the master job sheet (call it Master Job) is copied and the tab is named with the job number typed into the input box. Many thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a worksheet based on filtering of another? | Excel Discussion (Misc queries) | |||
| Extracting Data from another worksheet based on user input | Excel Worksheet Functions | |||
| Auto create a schedule based on a worksheet. | Excel Discussion (Misc queries) | |||
| Transpose and separating worksheet based on Input box name | Excel Programming | |||
| How to create a fill down that increments based on the worksheet n | Excel Worksheet Functions | |||
Linear Mode
