Reference a cell in the Advanced Editor of Power Query Editor

[Sigmawolf101]

Hello,

I'm trying to text in the advanced editor with a cell reference from a sheet in my workbook. I'm constantly having to manually update the advanced editor in 25 different tables which is taking me ~30minutes to run a report. Is it possible to do a cell reference for this? I've highlighted my example in the attached picture.

I've been stumped, any help would be REALLY APPRECIATED!

 

[Sigmawolf101]

*Replace a text

 

[sandy666]

post M not a picture

 

[Sigmawolf101]

post M not a picture

Post M? Sorry, what does that mean? I'm new to this site.

 

[sandy666]

on your picture is M (the name of Power Query language)

 

[Sigmawolf101]

Oh I see, yes it seems that M is the Power Query language.

 

[sandy666]

try

s666-PQ-sndt592f1.xlsx

Microsoft Excel Workbook

1drv.ms

 

[Sigmawolf101]

Wow, thanks for helping Sandy! I'm still in awe that you would take time on this. However, it's still generating an error message.

I added the code you provided and it gave me an "[Expression.Error] The column 'string' of the table wasn't found." error.

I'm trying to reference cell B2 on Sheet 2. I looked at your exampled and it appeared you named the cell "Table 1", so I made an assumption and did the same. I'm not sure if this contributed to the error. Was that a proper assumption on my part?

 

[sandy666]

there is Table1 not Table 1
the string should be as table with exactly the same header and table name or try to experiment with it

paste the rest of your M (after Source line) into Advanced Editor in my file and check if it will work

 

[sandy666]

Question: it's really hard to post M instead of picture?