I have a workbook with multiple sheets that each contain a table with two columns: an 'acronym column' and a 'description column'. This table takes place in columns 'F' and 'G' of each page.
On my title page I'm looking to have a button that launches a Userform that will allow the user to input:
- Initial Letter (of the acronym, this text box would be one letter maximum)
- Acronym
- Description
Where the initial letter will correspond with the relevant sheet it is to go on (the sheets are names 'A', 'B', 'C' ... 'X', 'Y', 'Z'), and then the acronym and description will take their respective places in the table - either as a new row at the end, or to be sorted alphabetically (either would be ideal but this would be a step I could do by myself later).
I can already create the Userform and name all the components, and I can send the data into the same sheet to specific cells, I cannot however, get the code to automatically add a new row and then insert the data like that.
Any help would be greatly appreciated.
Thanks.
On my title page I'm looking to have a button that launches a Userform that will allow the user to input:
- Initial Letter (of the acronym, this text box would be one letter maximum)
- Acronym
- Description
Where the initial letter will correspond with the relevant sheet it is to go on (the sheets are names 'A', 'B', 'C' ... 'X', 'Y', 'Z'), and then the acronym and description will take their respective places in the table - either as a new row at the end, or to be sorted alphabetically (either would be ideal but this would be a step I could do by myself later).
I can already create the Userform and name all the components, and I can send the data into the same sheet to specific cells, I cannot however, get the code to automatically add a new row and then insert the data like that.
Any help would be greatly appreciated.
Thanks.
