http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&group=microsoft.public.excel

"NetComm888" <netcomm888@yahoo.com> wrote in message news:5d605642.0402031938.437151a9@posting.google.com... > I know this is not the board for Excel. But since people here are very > knowledgeble and helpful, i wanna give it a shot > > I want to assign macro to a command button called "Enter". When I > first click that button, it is supposed to copy the 2nd row of a > spreadsheet called "stage" into the 2nd row of another spreadsheet > called "tblDemo". The 2nd row of "stage" will be dynamtically changed > from time to time. So everytime when you click "Enter", it is supposed > to copy the 2nd row of "stage" into the next row of "tblDemo". I'm > really not > good at writing macro in Excel. I used "record" to compile the > following codes. > But it will only copy into the same row of "tblDemo". So how > should I change the following codes to achieve the goal? > > > Sub Enter_Click() > Sheets("tblDemo").Select > Range("A3").Select > Sheets("stage").Select > Rows("2:2").Select > Selection.Copy > Sheets("tblDemo").Select > ActiveSheet.Paste > Sheets("stage").Select > Application.CutCopyMode = False > End Sub