What I would like to do is to write a code that copies a cells value, and then opens a seperate worksheet (already designed) and pastes the cells value to a new row in that worksheet and then saves the worksheet.

There will be twelve cells that have information that will need to be copied, but if I can get the concept of the code, I can add all the cells if I have code for just one.

Basically I have a report form that has a good amount of information in it. When the user is done filling out the report, a command button is clicked and a save macro copies the sheet, pastes to a new sheet and saves with a certain cell value as the file name. Before/during/after this macro runs, I would like 12 of the cells values to be copied and pasted in a new row on a log book style spreadsheet.