Bom Macro
Budget: $30 – $250 AUD
When a user enters a new issue ID number and hits the "Enter" key, a sheet should be created with that ID as its name, it should be pre-populated based on the template provided. Since it is a template, we don’t want users messing with it, you can hide sheets at the bottom. Unhide the sheet in this workbook and use it as the template when creating a new sheet. Google is your friend for this one.
Requirements:
A sheet should not be created if the ID number is empty
The function should only work if the "Enter" key is hit while in the ID column of the table
You should be making a copy of the template sheet rather than building it from the ground up in code
hint: It only takes ~20 lines of code to make this work, if you have more, you have probably used the wrong function
Requirements:
A sheet should not be created if the ID number is empty
The function should only work if the "Enter" key is hit while in the ID column of the table
You should be making a copy of the template sheet rather than building it from the ground up in code
hint: It only takes ~20 lines of code to make this work, if you have more, you have probably used the wrong function