I am trying to create a complete button on a front sheet called Audit that will update a sheet called table by using a command button, that will automatically save the data on the table sheet but clear the Audit sheet ready for the next data entry. My data is entered into 13 cells in column C each cell with its separate title, and I am entering data in 5 separate cells in columns E and F. I just want to click a complete button so this data is entered in columns in the table sheet.
I have attached a copy of the sheet I am trying to use
Bookmarks