Hi all,

Can anybody provide some code (as I am still new to this) that will execute
the following tasks

1) call the private macro called Private Sub CommandButton1_Click()
2) take the result from the above macro (which would be placed in the next
available row in column B in Sheet 1) and place it into the next available
row in column A of DATA worksheet
3) run the frmNewJob userform

any help appreciated and thanks in advance