Forum Discussion

FCD's avatar
FCD
Regular Visitor
2 years ago

Source from a variable range in a worksheet

Dear All, How to specify the source of a request from a range in a worksheet. I mean I wish the source to be the range from A3 cell to E&(LastRow) from worksheet1. I would prefer not to convert my...
Need Help
m_dekorte's avatar
m_dekorte
Resident Rockstar
2 years ago

Hi FCD 

 

Create an Excel Named Range. That can be made dynamic, with worksheet functions: OFFSET and COUNTA or INDEX and COUNTA. Next use Excel.CurrentWorkbook in Power Query to get the contents from that range.

 

I hope this is helpful