Maybe the code below will help: Sub test() Dim m1, Filenamev, Filenamev2 As String Dim loopvar, i As Integer m1 = Sheets("Sheet2"). Open Filename:=m1, Read Only:=True Sheets("sheet1"). For example, if you have a worksheet of expense figures for each of your regional offices, you might use data consolidation to combine these figures into a corporate expense worksheet. This master worksheet might contain sales totals and averages, current inventory levels, and highest selling products for the whole business. Select the check boxes under Use labels in, that indicate where the labels are located in the source ranges: Top row and Left column. For example, if you have a table with the number of sold items from each of your regional stores, you can use data consolidation to roll up these figures into a single report.To summarize and report results from data on separate worksheets, you can consolidate the data from each separate worksheet into one worksheet (or master worksheet).Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
Use the Consolidate Worksheets tool to summarize data from separate sheets into one.But don't cross this feature off your list because it sounds like something you don't need.You can also use it to quickly summarize data in a single sheet - without sorting the data.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.