How do I make power query look at a new table every time a new sheet Is added

[SPS41]

Hi, I am new to power query and I have a hopefully easy question.

I have a template which has a table and I have made power query look at it and make changes, thus creating a new sheet with those changes.

Now if I want to add a new sheet which has a table in it just like the template but with a different sheet name, is there a way to make power query also look at the new sheet. Is there some vba code I can use or is there a way to make power query automatically do this?
Any help would be appreciated and thanks in advance!

 

[SPS41]

Hi, I am new to power query and I have a hopefully easy question.

I have a template which has a table and I have made power query look at it and make changes, thus creating a new sheet with those changes.

Now if I want to add a new sheet which has a table in it just like the template but with a different sheet name, is there a way to make power query also look at the new sheet. Is there some vba code I can use or is there a way to make power query automatically do this?
Any help would be appreciated and thanks in advance!

Please let me know if any additional data/pictures need to be attached for additional info and I will do that!

 

[JEC]

You can use just power query. You can select the last sheet in your filter.

 

[SPS41]

You can use just power query. You can select the last sheet in your filter.

Sorry but I don’t know how to write code in power query, is there a way to select it or add it in the applied steps?

 

[SPS41]

Sorry but I don’t know how to write code in power query, is there a way to select it or add it in the applied steps?

Is there a way I can change this statement to make it look at the table on the recent sheet?

Excel.currentworkbook(){[Name =“table13”]}[content]

 

[JEC]

How about starting with just this

Excel.currentworkbook()

 

[SPS41]

How about starting with just this

Excel.currentworkbook()

I have a list of tables on that workbook, there are about 20 tables, but I want to only work with table 13, thus that extra step.

 

[JEC]

Your question is about referring to a new sheet. Which means you have to use a different table

 

[SPS41]

Your question is about referring to a new sheet. Which means you have to use a different table

Yes. Every new sheet that gets added has a table as column C and D. Is there a way to dynamically look at the new table on every new sheet that gets added and also use it as a source?

 

[JEC]

Yes but you told before you always wanted to use table13, which is not in line with the rest of your story