Jane Kisbey
asked on
MS Excel 2010 Macro to prompt user
Hello!
I have a database (attached) that allows for bid submittals to be created. Right now, the macro Add Work Item allows for a new worksheet to be created and it takes the user to the worksheet afterwards. This is great, the issue is that right now the code is set up to make the work item one number larger than the one previous to it in the table. However, this is not going to be the case for the user as work items can really be any number.
Is there a way that I could create a prompt that allows the user to enter in what they would like the work number to be and then once they enter in that work item number it takes them to the new worksheet, with the worksheet named after whatever the user entered as the work item? Additionally, the hyperlink feature in the Jump To column would still need to be the same number as whatever the user entered as the work item number.
Thank you so much!! Any help is greatly appreciated.
editing-EstimatingSpreadsheet.xlsm
I have a database (attached) that allows for bid submittals to be created. Right now, the macro Add Work Item allows for a new worksheet to be created and it takes the user to the worksheet afterwards. This is great, the issue is that right now the code is set up to make the work item one number larger than the one previous to it in the table. However, this is not going to be the case for the user as work items can really be any number.
Is there a way that I could create a prompt that allows the user to enter in what they would like the work number to be and then once they enter in that work item number it takes them to the new worksheet, with the worksheet named after whatever the user entered as the work item? Additionally, the hyperlink feature in the Jump To column would still need to be the same number as whatever the user entered as the work item number.
Thank you so much!! Any help is greatly appreciated.
editing-EstimatingSpreadsheet.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, I actually realized that I did not mean to say hyperlinking between sheets, just linking values. For example, linking whatever the user writes in B6 in the created worksheet to column D in Table1. Any help with this would be much appreciated as I have not had any luck yet! Thank you!
ASKER
Solved!
ASKER
I just have three more last questions...
First, if I want to rename the workbook, which I will have to when I give it to the users, how can I do this?
Second, column K of Table1 has a little check box so that the user can enter if the worksheet for a certain work item is completed or not, right now only the first row has this check box and when the new work item is created it is not copied into the next row. How can I make sure that the check box is copied into the new row when the Add Work Item macro is run?
Third, I asked this in a separate question but I will also add it here... I need to hyperlink some cells from the created worksheet to the row in Table1. What formula is required for this to occur? For example, linking column D in the summary sheet to cell B6 in the created worksheet based off the template.
Thank you so much! I can't explain how helpful this has been!