Forum Discussion

Copper Contributor

Oct 02, 2019

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...

excel

Formulas and Functions

Macros and VBA

PascalKTeam

Iron Contributor

Oct 09, 2019

anahka_7

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_7
Copper Contributor
Oct 09, 2019
PascalKTeam
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.
- PascalKTeam
  Iron Contributor
  Oct 09, 2019
  anahka_7
  
  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)