Hey guys,
Really needing some help with this, it’s had me stuck for hours now, countless google searches and YouTube videos I still can’t do it haha.
My excel experience and knowledge is umm poor to say the least, I think the last time I used it was about 10 years ago at high school to create a table or something.... so please give me an answer I can understand haha.
So I’ve created (well creating) an invoicing system to invoice clients, I so far have a database sheet “material database”, a sheet “add new item” which I’ve made a data entry form (it’s not a proper data entry form just something I’ve made up on a sheet, I have dependent drop down lists which I couldn’t figure out how to do on a proper data entry form hence why I’ve done it like that) and a sheet “control page” which has a series of buttons that will perform functions (kind of like a home page)
Now this is where I’m stuck, I click button “add new item” which directs me to the sheet “add new new item” (data entry sheet) I fill out the form as necessary and click a form control button “insert” which in theory should copy the data I’ve entered into the sheet and paste it into the material database table located on the “material database” sheet. I just cannot figure out how to make it do it so that it inserts the data into a new row in the table..
Any help is much appreciated.
Cheers
Really needing some help with this, it’s had me stuck for hours now, countless google searches and YouTube videos I still can’t do it haha.
My excel experience and knowledge is umm poor to say the least, I think the last time I used it was about 10 years ago at high school to create a table or something.... so please give me an answer I can understand haha.
So I’ve created (well creating) an invoicing system to invoice clients, I so far have a database sheet “material database”, a sheet “add new item” which I’ve made a data entry form (it’s not a proper data entry form just something I’ve made up on a sheet, I have dependent drop down lists which I couldn’t figure out how to do on a proper data entry form hence why I’ve done it like that) and a sheet “control page” which has a series of buttons that will perform functions (kind of like a home page)
Now this is where I’m stuck, I click button “add new item” which directs me to the sheet “add new new item” (data entry sheet) I fill out the form as necessary and click a form control button “insert” which in theory should copy the data I’ve entered into the sheet and paste it into the material database table located on the “material database” sheet. I just cannot figure out how to make it do it so that it inserts the data into a new row in the table..
Any help is much appreciated.
Cheers