Yes, it is simple to get the value from a named range
let name = Excel.CurrentWorkbook(){[Name=RangeName]}[Content],
I am a power query novice so please provide solutions (if there any) at a level I can understand. Here is my problem:
My workbook will contain...
So, I wish Excel or Google Sheets had the option of keeping links intact when you did a drop down list in data validation, but it doesn't. I decided the...
bgiovanni1! Yesterday, 08:54 PMThanks for the assist! I was thinking something similar but you got to it b 4 me ...
Excel:data validation drop-down list- Populate the matching hyperlink from another co
Consider using a small macro. In the attached, make choices in the green shaded area. To view the code, right-click on the sheet's tab and choose View...
p45cal Today, 02:27 PM