Saving a generated part number to a log in the next worksheet.

[tespinosa]

I have created a ID generator that will then need to be saved to a log in the next worksheet.

I have created two command buttons, one to clear the form and another to save it to the log. I can not place a command that will identify the next open cell in a specific column for the log worksheet.

Another thing I need to make sure is that the ID number is not duplicated so I would also like to code a command to feed back an error if the ID number generated is already in the log.

here is my code so far:

Private Sub CommandButton2_Click()

Range("C20").Select
Selection.Copy

Sheets("Part Number Log").Select

Range(LstRw).PasteSpecial
Selection.PasteSpecial Paste:=xlPasteValues



End Sub


Any help would be greatly appreciated.

 

[tespinosa]

Awesome Help!