Data Update using VBA

[yogeshCR7]

Hello Everyone!

I have two files named Purchase Requistion (PR) and Database (DB). PR is in the format of a form which they fill in order to raise a PR request. This file is then "Save As" with a different name so as not to disturb the native file "PR".
DB is a table format, which takes the data from the cells and creates a order number.

I have written a VBA code for reflecting, the data from PR to DB. Put as soon as the PR file is saved as with another name, the new data file in the PR file gets reflected in the same cells in the DB file, basically overwrites the previous data.

Requirement :
1. There is are multiple checkboxes in the PR file, I want to reflect that data in the DB file. I wrote a code for that, it seems to work but when a user clicks on other checkbox it does not update or when its unchecked the data still remains in its place. What is missing or incorrect?
Sub CheckBox10_Click()
If Check_Box_10 = False Then
Workbooks("DB.xlsm").Worksheets("Sheet1").Range("A4").Value = "Betriebsstoffe"
Else
Workbooks("DB.xlsm").Worksheets("Sheet1").Range("A4").Value = " "
End If
End Sub
2. I want to update the DB in such a way that the previous data is intact and the new data gets reflect in the empty column after the previous data. To find the new empty row I have written a code so that is solved.

If you want me to put the whole code, let me know