Use of & to include a cell in a reference to an external Excel table

		Microsoft Office Forums > Microsoft Excel > Excel
Use of & to include a cell in a reference to an external Excel table

FAQ

Thread Tools

Display Modes

09-22-2023, 11:33 AM

Rog7

Windows 10 Use of & to include a cell in a reference to an external Excel table

Office 2021

Novice

Join Date: Sep 2023

Location: London

Posts: 4

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When inserting row in table, how do I adjust cell reference to new row	Peterson	Excel Programming	1	01-16-2022 01:06 PM
Find/Replace a cell with external reference	John Moses	Excel	1	01-03-2020 05:52 AM
Using Cell Values in Active Sheet to Populate Path to External Reference Link	wowcrofty	Excel	4	12-19-2016 12:29 PM
Reference Word Table Cell Using Offset?	wlcdo2	Word VBA	2	06-19-2016 08:53 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.