Re: Adding New Rows To Lookup Table
Thanks for your replies.
I have attached my whole project.
What i want to achieve is to add new members when i click the "Add new member" button from the Form called "MembershipID". This button takes me to the form called "NewMembers", where people can input their information and add themselves into the data spreadsheet, called "Data".
As you can see in the form called "NewMembers" i don't know what code to put into the button "Add Member", without replacing the current members in the data worksheet.
All data can be found in the "Data" worksheet.
Sorry, I'm new to Excel/VBA world and would GREATLY appreciate if anyone could help me out.
Thanks in advance.