Forum Discussion
Seeking solutions/workarounds for creating Excel Master Workbook
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 re...
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.
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)