DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,640
- Office Version
- 365
- Platform
- Windows
Can someone please help me?
I wish to have the date in my ExcelTable become the source for a PQ Query. I can then change the date in H2 and the query will get the standings for that date. How do I create the parameter and then use it as the source?
My Table is called T_NHL_Standings
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I wish to have the date in my ExcelTable become the source for a PQ Query. I can then change the date in H2 and the query will get the standings for that date. How do I create the parameter and then use it as the source?
My Table is called T_NHL_Standings
G | H | I | |
---|---|---|---|
1 | NHL_Date | NHL_Address | |
2 | 10/13/2017 | http://www1.nhl.com/ice/standings.htm?date=10/13/2017&season=20172018&type=lea | |
3 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Q_Data
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>