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]

Awesome that worked in yours and mine! I was able to get it to work in my file too! However, I needed to create a table that then linked to Cell B2 to get it to work. Is there a way to reference a single cell in M and avoid making a table?

 

[sandy666]

of course it works
you can try with named range where single cell is a range

 

[Sigmawolf101]

Thank you so much, I appreciate all your help!

 

[sandy666]

You are welcome
so hit Like in the posts which have helped you
Have a nice day