Hello!

I am trying to write a macro that copies data from one sheet in a workbook to another sheet in different workbook in Excel 2007. I could really use some guidance on what to do next. Here's the details. Both workbooks will have their own name that will not change over the time the macro is used. ie. Workbook1 and Workbook2 I am looking to copy Column A through Column G every time I run the macro from Workbook1 to Workbook2. The columns will not change. The rows may be longer or shorter each time the workbook1 is updated. Workbook 1 will be updated manually. I was hoping for workbook2 I could run a macro. I tried the record macro feature in excel and it works fine for the first time. But, the second time it does not paste the updated data in workbook1 to workbook2. It's like it references the data that is already on the clipboard not the new data in the workbook. Does anyone have code to make this work or a reason why this is not working? I would really appreciate it.