Senin, 01 Desember 2014

[ExcelVBA] macro to aggregate worksheets from many workbooks


Anyone point me towards a macro to drag all the worksheets from a
number of workbooks in a directory sequentially into a single
worksheet with the source filename and source sheet name in the first
two columns

the data from the sheet would then be inserted line by line with the
same prefix column

the range of data to be grabbed can be fixed in terms of a range

I am trying to aggregate a large number of sheets within a large
number of workbooks where the originators have kindly produced
sequential blocks of data split between worksheets using what should
have been column data as the tab name!!!


Many thanks

Dr B





Posted by: Dr John C Bullas <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Yahoo Groups
Test Campaign
subject line for test

Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar