I am looking to add a checkbox button that when clicked will replicate the row of data at the end of the excel worksheet and activate a form to add additional info to the current row on the excel. Basically this is to mark a task as complete, then reopen the task at the bottom with new dates, so that it can be undertaken in a few weeks time.
I have produced a form for the initial data entry as follows...
Private Sub CommandButton1_Click()
Dim LastRow As Range
Dim TaskManagerTable As ListObject
'Add row to bottom of task manager table
'Enter data from form into new row
Set TaskManagerTable = ActiveSheet.ListObjects("Tasks")
Set LastRow = TaskManagerTable.ListRows(TaskManagerTable.ListRows.Count).Range
'Get the highest number in column A and assign it to variable MaxNumber
MaxNumber = Application.WorksheetFunction.Max(Range("A:A"))
YOu have almost successfully created a database! If you are new to VBA, then you would pick up access just as fast, and would get a better product for what you have described! EXCEl is for calculations and such, not data entry and record keeping.
Build some tables (if you need help, just ask!)
Build a form that is mapped to the table (the form will automatically input the data into a blank "ROW"! Magic!
Build reports based on what you need back out!
It is that simple, and easier than learning how to code, as there is no code besdies SQL! Which BTW is an actual code, and pretty robust on a massive machine like an IBM with BI!