Hi
I'm new to vb but have managed to create a user form to make adding information to a spreadsheet easier. I have a command button named 'Add' and when clicked this automatically updates the worksheet named 'Database'.
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Database")
End Sub
However, sometimes all the information needed to complete an entry is not available and I would like to be able to save the information I have to a worksheet named 'Draft' so that I can retrieve it later, add the missing information and then save it to the 'Database' worksheet. This sounded simply when I thought about it, but I am now struggling to work out how to do it. I would really appreciate some help, or pointing in the right direction if this has already been dealt with on the forum.
Thanks in advance
I'm new to vb but have managed to create a user form to make adding information to a spreadsheet easier. I have a command button named 'Add' and when clicked this automatically updates the worksheet named 'Database'.
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Database")
End Sub
However, sometimes all the information needed to complete an entry is not available and I would like to be able to save the information I have to a worksheet named 'Draft' so that I can retrieve it later, add the missing information and then save it to the 'Database' worksheet. This sounded simply when I thought about it, but I am now struggling to work out how to do it. I would really appreciate some help, or pointing in the right direction if this has already been dealt with on the forum.
Thanks in advance