Microsoft Office Forums - View Single Post - [Solved] Use of & to include a cell in a reference to an external Excel table

Thread: [Solved] Use of & to include a cell in a reference to an external Excel table

View Single Post

Old

09-22-2023, 11:33 AM

Rog7

Rog7 is offline

Rog7 uses Windows 10

Windows 10 Rog7 uses Office 2021

Rog7 uses Office 2021

Office 2021

Novice

The original poster

Join Date: Sep 2023

Location: London

Posts: 4

Rog7 is on a distinguished road

Thumbs up

Found a solution:

It took me a few hours to amend all 20+ workbooks to put required data in one particular sheet in each workbook.

Now Power Query can provide the summary report as wanted.

Reply With Quote