title: Excel VBA, find the next empty cell
body: <p>What I am trying to do should be easy but the noob in me is showing.  I am creating a database in excel using a dataentry form in another worksheet.  When the “enter” button is clicked, it runs a macro that places the info from the dataentry sheet to an Excel database.  The problem is, of course, that the next record overwrites the previous record.  What I want to do is copy the data from a field in the dataentry form, then go to the database and find the next empty row and paste the info there.  Ideally, the procedure would continue and copy the next field in the dataentry form, find the empty cell to the right of the data previously pasted and then repeat until all 6 fields have been copied and pasted to the excel database.  I want to do this all in excel rather than into an access database.  Any ideas?  </p>