Macro To Copy Specific cells From Multiple Workbooks to Summary Workbook

Mooseman60

New Member
Joined
Sep 30, 2010
Messages
49
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

BuildingQ1 Total Q1 GMWorkbookQ2 Total Q2 GM
E19L10L91L17L15+L16
E19L10L92L17L15+L16
E19L10L93L17L15+L16
E19L10L94L17L15+L16
E19L10L95L17L15+L16
E19L10L96L17L15+L16
E19L10L97L17L15+L16
E19L10L98L17L15+L16
E19L10L99L17L15+L16
E19L10L910L17L15+L16
E19L10L911L17L15+L16
E19L10L912L17L15+L16
E19L10L913L17L15+L16
E19L10L914L17L15+L16
E19L10L915L17L15+L16
E19L10L916L17L15+L16
E19L10L917L17L15+L16
E19L10L918L17L15+L16
E19L10L919L17L15+L16
E19L10L920L17L15+L16
E19L10L921L17L15+L16
E19L10L922L17L15+L16
E19L10L923L17L15+L16
E19L10L924L17L15+L16
E19L10L925L17L15+L16
E19L10L926L17L15+L16
E19L10L927L17L15+L16

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

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top