# Macro To Copy Specific cells From Multiple Workbooks to Summary Workbook

#### Mooseman60

##### New Member
Hi I am using Excel 2003 and have 27 different workbooks in the same folder in My Documents and would like to know how i can create a Macro to copy cells from all these workbooks to one new summary workbook. All the data is in the same cell numbers in all 27 workbooks.

Eg: The following summary workbook cells to save data too are A3, B3, C3, E3, F3

The cells from the 27 workbooks are E19, L10, L9, L15+L16

So A3 = E19 B3 = L10 C3 = L9 E3 = L17 F3 = L15+L16

I hope this makes sense

Last edited:

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Hi I am using Excel 2003 and have 27 different workbooks in the same folder in My Documents and would like to know how i can create a Macro to copy cells from all these workbooks to one new summary workbook. All the data is in the same cell numbers in all 27 workbooks.

Eg: The following summary workbook cells to save data too are A3, B3, C3, E3, F3

The cells from the 27 workbooks are E19, L10, L9, L15+L16

So A3 = E19 B3 = L10 C3 = L9 E3 = L17 F3 = L15+L16

I hope this makes sense See attached worksheet

 Building Q1 Total Q1 GM Workbook Q2 Total Q2 GM E19 L10 L9 1 L17 L15+L16 E19 L10 L9 2 L17 L15+L16 E19 L10 L9 3 L17 L15+L16 E19 L10 L9 4 L17 L15+L16 E19 L10 L9 5 L17 L15+L16 E19 L10 L9 6 L17 L15+L16 E19 L10 L9 7 L17 L15+L16 E19 L10 L9 8 L17 L15+L16 E19 L10 L9 9 L17 L15+L16 E19 L10 L9 10 L17 L15+L16 E19 L10 L9 11 L17 L15+L16 E19 L10 L9 12 L17 L15+L16 E19 L10 L9 13 L17 L15+L16 E19 L10 L9 14 L17 L15+L16 E19 L10 L9 15 L17 L15+L16 E19 L10 L9 16 L17 L15+L16 E19 L10 L9 17 L17 L15+L16 E19 L10 L9 18 L17 L15+L16 E19 L10 L9 19 L17 L15+L16 E19 L10 L9 20 L17 L15+L16 E19 L10 L9 21 L17 L15+L16 E19 L10 L9 22 L17 L15+L16 E19 L10 L9 23 L17 L15+L16 E19 L10 L9 24 L17 L15+L16 E19 L10 L9 25 L17 L15+L16 E19 L10 L9 26 L17 L15+L16 E19 L10 L9 27 L17 L15+L16

<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

Replies
9
Views
372
Replies
2
Views
239
Replies
14
Views
969
Replies
7
Views
328
Replies
16
Views
736

1,212,096
Messages
6,105,940
Members
447,985
Latest member
gigi11

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back