Can I create a changeable table template for multiple workbooks that automatically update when I update the template?

[ashley12]

Hi everyone.

I'm trying to create a Master Excel sheet that stacks up multiple children spreadsheets that have the same set of columns. I can easily do that using power query or the Data tab in Office 365. However, the problem is I may want to add or remove columns of the children sheets later, due to they are still being developed. Is there any way I can modify the columns of all of the children sheets at once?

Thank you

 

[vladimiratanasiu]

Assuming that the children files include a similar structure, select all of them and insert / delete the needed columns in the first one. Then, save the changes and unselect the files .

 

[ashley12]

Thanks. But do you mean highlighting all the range of each table by holding control?

 

[vladimiratanasiu]

Select all files as in the attached image, then make the changes you need in the first file.

 

[ashley12]

OK thanks

 

[vladimiratanasiu]

I'm glad to help you.