Forum Discussion
Seeking solutions/workarounds for creating Excel Master Workbook
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
https://kteamch-my.sharepoint.com/:v:/g/personal/pascal_kiefer_kteam_ch/EbxHRcUxqEFNrgdZV2zJEEQB6-hdA00X_R9lfqtUWqqAZg?e=GnMEqk
- anahka_7Oct 09, 2019Copper Contributor
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.
- PascalKTeamOct 09, 2019Iron Contributor
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)