Sum Up Multiple Workbook

[bigJD]

Hello everyone,

I was doing a lot of work summing up 5 workbook. I know the time will be lessen if I will use macro. I have 5 workbooks with same formats and each contains two worksheet. Each workbook is updated weekly so what I need to do is to get the Sum of the data from all workbook in an specific column from the two worksheet and get the total in a new workbook which has the same format as well as the 5 workbook. Is there any macro to do that? To produce a summary on 5 workbook into one?

Thanks.

[parttime_guy]

Hi BigJD,

Here is a link to a macro provided on this site itself:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=773

Suppose you have several workbooks in a directory, each with one or more sheets and you want to put all the worksheets from all the workbooks into one (or more, if necessary) worksheet. This macro does all the work for you. Each worksheet must have the same structure.

U could run this macro whenever necessary and total the relevant columns.

Hope this helps.

Regards