Move to next row??

[Chris Watson]

On sheet 1 I have 6 cells that I will enter data, I want to add a button that will clear the cells and transfer the data to sheet 2 Data sheet, and repeat this as I add data in the 6 cells on sheet 1. Is this possible???

[modytrane]

it would help if you were a bit more specific or with a sample workbook.
Do you want these 6 cells to move to the same place on sheet2 everytime?
In other words, do you want to overwrite previous data or do you want to append the records and write in the next row?
Creating buttons to clear and move data is not a problem.
modytrane

[Chris Watson]

Thanks for your reply but to explain more clearly! Sheet 1 has 6 cells in a row A1 to A6. I want to add a button, call it SAVE, when I click on this button I want the data I have entered in the 6 cells to clear so I can use them again and the data transfered to sheet 2. Sheet 2 will have 6 named headed coloums where the data will be stored, row B will have the first 6 cells of data, when I click the save button on sheet 1 it will clear and the data will be transfered to row C of sheet 2, so on and so forth?