Copy data from one spreadsheet to another...

Hello,
I need to copy data from same formatted spreadsheets to another (master) spreadsheet. Using Ctrl-C and Ctrl-V is very annoying and time consuming considering i have hundreds of files(of the same format) i need to copy from. I have attached two spreadsheets; I need to copy data from Template.xls to Security Exception Database.xls. Is there any way to automate this? Each file (in the format of the Template) must be copied into a raw in Security Exception Database. Any help will be very appreciated.

Thanks,
Dauren

Try the macro below

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module in the Security Exception workbook.

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

Change the MyPath to the folder where your temple files are stored and add more lines as indicated to transfer the remainder of the data cells.