Move to the next row

[dekalbemp]

I have a certificate in Excel that contains two field that change one is a random genrated number and the other is changed manually by entering an employee's name. All this occurs on sheet one. I have sheet two that is linked and changes also. I need to keept the information and automatically have excel move to the next row if data is detected. Looks liket this

Cell A Cell B
Row 1 123456 Jane Doe

When I enter the information on sheet one for the next record John Doe 456123 I need it to look like below instead of replacing the information in row 1

Cell A Cell B
Row 1 123456 John Doe
Row 2 123456 Jane Doe

 

[MrKowz]

There are a couple ways I would suggest handling this:

1. Create a Worksheet_Change event that will monitor for when B1 on the first worksheet changes, then it will copy over the data to the next row on your second sheet
2. Create a button that will bring up an input box that asks for an employee name. Then when you hit OK, it will create the record on the second sheet.

Personally, I would reccommend the second option, because if you accidentally change B1 under the first method, it will copy over the record anyway.

Let me know which method you prefer (if either).