Macro to move data from Workbook A Spreadsheet A Col. 3 into Workbook B - Spreadsheet B Col. 3

[macrousr1]

I have been tasked with creating a macro for this is a report that is run pretty frequently and it takes some time to put together. I tried recording the macro but it doesn't work out the way I intend for it too. I am not very familiar with VBA but a macro would greatly help with this process and shorten the production time.

The Objective: Pull in data from Workbook B - Spreadsheet B - Cols 3, 6, 9 and 12 into 4 blank columns in Workbook A Spreadsheet A. I pull in the data from Spreadsheet B into Spreadsheet A via a Vlookup against the cost center numbers and pull in the data contained in columns 3, 6, 9, and 12, respectively.

Background on spreadsheets: Spreadsheets A & B are pretty much mirrors of each other in terms of format. However, in spreadsheet A there are 18 columns (14 standard and 4 blank columns that I create) in each spreadsheet.

Spreadsheet A
Col 1: Cost center ; Col 2: Cost center Desc ; Col 3: Need Workbook B Spreadsheet B Col 3 data here ; Col 4: Illness

Spreadsheet B
Col 1: Cost center ; Col 2: Cost center Desc ; Col 3: Move data to Workbook A Spreadsheet A Col 3 ; Col 4: Illness



I'm using MS Office Excel 2010 - Basic Office Applications and MS Windows 7 Enterprise SP 1. Note: Each workbook contains other spreadsheets but I am only focused on working with Spreadsheets A & B, respectively.

Thanks in advance for any assistance offered.