Oct 02 2019 10:54 AM
I'm trying to find solutions for creating a master template in Excel. We have almost 100 Excel workbooks where data in them varies but the formatting and cell and row layout including header names remains the same. When a row is deleted in one, it needs to be deleted in all of them. When a row header is updated, it needs to be updated in all of them. When conditional formatting changes in one, it needs to be updated in all of them. Get the gist?
Solutions I've researched that won't work:
I've seen numerous threads from people looking at how to create a master template in Excel. I get that its not possible (and I have no idea why Microsoft in all its wisdom hasn't created function yet), but what I'm looking for are possible workarounds. Right now the process can take a couple people several days to update all of the workbooks. Any work arounds that can reduce this to a single person in just a few hours would be fantastic.
Oct 09 2019 01:02 AM
If I understand correctly you should just be able to select all worksheets you want to change and then make the change. Show this video where I show what I mean for the header
Oct 09 2019 05:08 AM
I can't get the video to load, but I need a solution for workbooks, not worksheets. We're working with around 100 workbooks and each of those have about 10 different worksheets.
Oct 09 2019 05:12 AM
Oh sorry I didn't see that you were talking about multiple workbooks. Well that will be tricky I guess, I don't know any solution for that. Hopefully somebody else can help out.
My solution was about multiple worksheets within one workbook (I uploaded the video to dropbox this time, maybe that works better: https://www.dropbox.com/s/ogh988aom3dosok/master%20workbook.mp4?dl=0)