Excel 2013, Windows 10
I have a need to create a worksheet data entry form (as opposed to the Data Form dialog auto generated by Excel) that will populate the entered information into a table on another worksheet. As each submission will be a new entry to the table, a new table row will have to be created, The data to go in it's respective cell, and then clear the form for the next entry without disturbing the information in the table.
I believe this can be done in a macro that I can assign to a Submit button. I just don't know how to write the macro. I have spent several hours trying. I've been able to do this with a Range.Copy function. But that only worked with absolute fields (it only would populate the one same row/cells referenced).
Would anyone be able to help?
If It'll help, the field/column names can be Mon, Tue, Wed, Thurs, and I can modify from there.
Thanks much in advance.
Bookmarks