Consolidate data from workbooks and create link formulas in the summary workbook

Hello,

The following code is from Ron De Bruin's website, http://www.rondebruin.nl/summary2.htm . I am using it to generate a summary from different workbooks and at the same time generate/create links in the summary workbook.

My question is, how do I select the first sheet of every workbook, irrespective of it's name? I tried changing ShName = "Sheet1" but to no avail.

Please Login or Register  to view this content.

Thank you

Am I correct to assume that the ShName is used to indicate from where the data will be pulled? Or is it for simply to list the name of the sheets in the summary workbook? I figured if it's only used for listing the name of the sheets from where data was pulled, I could remove it altogether.

arlu1201, thank you very much. Exactly what I was looking for.

Hello sans,

Can you please attach a workbook with vba in it? I would be helpful to see how it works.

Thank you

Hi Naja,

Download the zip file, unzip it to your desktop, open one of the workbooks, use the following code

Please Login or Register  to view this content.

and a new workbook will pop up that copies the TOTAL row (B7:AA7) from the two workbooks in the folder and pastes them in the newly created workbook.

Hope the above makes sense.