I have a workbook that I am using the first worksheet for data collection.
Everytime the workbook is opened I would like a sequence number populated
automatically. (i.e. 1,2,3,etc.)
I created a macro that is assigned to a "submit" button. When the button is
selected the data transfers to the second worksheet. How do I make the data
insert in the next empty row on the second worksheet? I appreciate anyone's
help on this.

Thanks