Hi,

I have an about 50 cost center reports where the formatting are all the
same, numer of rows, columns etc. What I would like to do is to have a
"master" file where I can make formatting changes which then applie all my
cost center reports when updated.

I'd appreciate any help in how to create this type of "master" formatting.

--
Niklas

Do you have 50 spreadsheets (separate files) or 50 sheets in one workbook?

Basically you need to have a piece of code which selects the source sheet,
copies it
selects the other sheet and performs Paste Special|Formats

like the one below;
(this will copy the formatting on the current sheet to Sheet3)
Sub Macro1()
Cells.Select
Selection.Copy
Sheets("Sheet3").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
"Niklas" wrote:

Hi,

I have an about 50 cost center reports where the formatting are all the
same, numer of rows, columns etc. What I would like to do is to have a
"master" file where I can make formatting changes which then applie all my
cost center reports when updated.

I'd appreciate any help in how to create this type of "master" formatting.

--
Niklas

Hi,

I have 50 separate files that need to be updated based on the format of the
master. Maybe a macro that opens each file and copy/past the format and then
closes file?

--
Niklas


"Sheeloo" wrote:

Do you have 50 spreadsheets (separate files) or 50 sheets in one workbook?

Basically you need to have a piece of code which selects the source sheet,
copies it
selects the other sheet and performs Paste Special|Formats

like the one below;
(this will copy the formatting on the current sheet to Sheet3)
Sub Macro1()
Cells.Select
Selection.Copy
Sheets("Sheet3").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
"Niklas" wrote:

Hi,

I have an about 50 cost center reports where the formatting are all the
same, numer of rows, columns etc. What I would like to do is to have a
"master" file where I can make formatting changes which then applie all my
cost center reports when updated.

I'd appreciate any help in how to create this type of "master" formatting.

--
Niklas