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

ashley12

New Member
Joined
Dec 6, 2020
Messages
43
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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 .
 
Upvote 0
Thanks. But do you mean highlighting all the range of each table by holding control?
 
Upvote 0
Select all files as in the attached image, then make the changes you need in the first file.
 

Attachments

  • Screenshot 2020-12-10 09.05.49.png
    Screenshot 2020-12-10 09.05.49.png
    164 KB · Views: 17
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,725
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top