Copying information from one sheet to another sheet, creating a new row

[pollitofeliz32]

Hello all,

What i am trying to do here is copy just some basic information from a sheet named "CHECKSHEET" to another named "Info", after a button is clicked.

Here is what i have so far for the macro (note that the information that will be entered by the user will be found in D1, D2, D3, D4, D5, B6, and D6)

Please Login or Register  to view this content.

This works well, except that everytime the CHECKSHEET information will be different so we need to create a new row in the "Info" sheet instead of overwritting the same row over and over. After the information is copied over from one sheet to another, how do i make it skip to a new row for the next data entry? So if i close the excel document after entering data once, i want to be able to enter new information that will be going to the next row the next time it is opened & another entry is provided ( meaning we will have the previously entered information and then the new information if that makes sense)

Any input is highly appreciated


Thanks

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)