as I do not have all your macro codes I cannot check completely
now you modify you button click codes like this (i assume the main data base is sheet 1 and if necessary modify this line)
Private Sub ND_click (ByVal Target As Range)
Range(Cells(Selection.Row, "a"), Cells(Selection.Row, "b")).Select
'the above two lines select A and B column only whatever the person selects
'But he has to select at least one cell.
Ty the above code. there are comments on the 4th and 5 th line .
these lines can be deleted once you get the hang of it.
If this is ok post confirmation.