Combine Selected Sheets in Workbook

[AllisterB]

I have a workbook with 3 sheets that have the same structure, a range named r_Range and have the letters "ab" in the sheet name. I want Power Query" to combine Range r_Range from all the sheets that conytaing "ab" in eth sheet name.

How would I do this. Do I use a Excel.CurrentWorkbook ?

Thank You

Allister

[mohadin]

Hi
Alternative VBA

Please Login or Register  to view this content.

[AllisterB]

Thank You for your efforts mohadin but I was looking for the Power Query approach :-)

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[AllisterB]

Thanks bo rwhat does Name and Value refer to

[Bo_Ry]

Name => Range name

Value => Column header