Good afternoon everybody, I would like to create in a Sheet named "Report" a compilation of data located in the Sheets "Sheet1" and "Sheet2" I already managed to obtain a list of active Sheets linked with hyperlink via a macro : result (in a sheet named "P.M.T" in cell A1) : Programme Template (2) Sheet1 Sheet2 Report (obviously, this list will grow in time) Is there any possibility to do this "merging" of data from the row 4 up to the row 500 of each active Sheet ? Is there any possibility to create this macro from the sheets names in the range A1:A200 ?? Thank you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Compilation of data contained in a list of Sheets

Thread starter Tristan Danic
Start date Dec 6, 2013
Tags

merge data reporting tool

Tristan Danic

New Member

Dec 6, 2013

Good afternoon everybody,

I would like to create in a Sheet named "Report" a compilation of data located in the Sheets "Sheet1" and "Sheet2"

I already managed to obtain a list of active Sheets linked with hyperlink via a macro : result (in a sheet named "P.M.T" in cell A1) :

[TABLE="width: 164"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Programme Template (2)[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[/TR]
</tbody>[/TABLE]
Report

(obviously, this list will grow in time)

Is there any possibility to do this "merging" of data from the row 4 up to the row 500 of each active Sheet ?
Is there any possibility to create this macro from the sheets names in the range A1:A200 ??

Thank you.