Files with different sheets (incl. Names) Submit

[#1]

Hello everybody,

we have files from Excel with multiple sheets, all of which are to be added together.

These sheets have all actual name (that affect the region incl. Sales figures).

These are now all be inserted.

According to our trainers we should install a "LOOP" here.

Unfortunately, this is not available.

Can someone help me here?

many Thanks

Michaela

[Gysbert_Wassenaar]

See this discussion: Load data from multiple worksheets in multiple Excel workbooks