petraidm58
New member
- Joined
- Dec 12, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
[FONT="]I am a power query novice so please provide solutions (if there any) at a level I can understand. Here is my problem: [/FONT]
[FONT="]My workbook will contain a large number of worksheets. The sheet name will be a stock ticker symbol and a cell on that worksheet contains a formula that retrieves stock ticker from that cell which I have made a named cell. All of the power query code is written and it retrieves 5 years of data from the intranet without issue. I want to be able to just copy this worksheet and rename it ( a different stock symbol) and viola be done. My problem is the power query on this new worksheet refers to original sheet's named cell or named range.[/FONT]
[FONT="]Is there anyway to pass a parameter from the Active Sheet such that I don't have to go into the query code on each copied worksheet and change the named cell or hard code the source? In other words, I want to use the same power query code on multiple worksheets in the same workbook and be able to retrieve the source from Cell A1 of each worksheet without having to go into the code for that worksheet and editing the code.[/FONT]
[FONT="]Thanks[/FONT]
[FONT="]My workbook will contain a large number of worksheets. The sheet name will be a stock ticker symbol and a cell on that worksheet contains a formula that retrieves stock ticker from that cell which I have made a named cell. All of the power query code is written and it retrieves 5 years of data from the intranet without issue. I want to be able to just copy this worksheet and rename it ( a different stock symbol) and viola be done. My problem is the power query on this new worksheet refers to original sheet's named cell or named range.[/FONT]
[FONT="]Is there anyway to pass a parameter from the Active Sheet such that I don't have to go into the query code on each copied worksheet and change the named cell or hard code the source? In other words, I want to use the same power query code on multiple worksheets in the same workbook and be able to retrieve the source from Cell A1 of each worksheet without having to go into the code for that worksheet and editing the code.[/FONT]
[FONT="]Thanks[/FONT]