Need to Pull Data from Named Ranges in Separate Workbooks

mtquest

New Member
Joined
Oct 16, 2009
Messages
1
I have several workbooks in a folder. Each has a transaction worksheet and a summary worksheet. The number of rows of data in each summary sheet differ from workbook to workbook but all fall within a dynamic range having the name "AData". I would like to consolidate those summary records into a separate workbook. Formulas do not seem to be the most efficient solution but I welcome any suggestions. I believe a macro may be the better solution and for that I am a little lost. Can anyone help?
 
Last edited:

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,598
Members
412,330
Latest member
carlosjw
Top