Entering Data on Sheet One, Transfer to Sheet Two

[XpressAg09]

Hi all, I've been mulling over how to best go about a particular task. Long story short, I think what I need to do is use combo boxes and check boxes to set row 2 of sheet 1 to a particular combination of data. Row 1 would be the headers, row 2 would be the data.

Once the selections have been made, is there a quick macro I can use (I know nothing of macros) to copy the data from row 2 of sheet 1 and place it in first empty row of sheet 2.

I would prefer to have a button on the screen do this...is that possible?

[Mumps1]

This could quite easily be done with a worksheet_change event. You would enter the data in row 2 and when you enter the last piece of data in the last column in row 2, the data would be copied automatically to sheet 2. Assuming that the last column that will have data is the same each time, what is the last column in which you will enter data?