Greetings All,

I have two Static Workbooks, and I need to have a macro that will copy data from workbook 1 columns, into workbook 2 columns. I'm working with Excel 2007. I'm sure this is very basic, but I just need some insight.

I have a workbook with name, address, SKU and such, and a different workbook that needs that information from the first one. Both workbook formats will never change, static, however the information in updated daily.

Thank you for your help.