Formatting

[scottie1]

Hello there and a happy new year to everyone

I would like to know how to format all sheets in a workbook the same, For example I've designed a spreadsheet to work for me now and duplicated it to last for a year but say during that year I want to upgrade it. ie new rows, columns, colours, fonts, formulas etc. If i change 1 sheet how do i change the rest of the sheets by a click of a button but to keep the original calculations in the right cells.

 

[BrainB]

A general question, so a general answer.

1. Hold down Control or Shift key while selecting sheet tabs to group worksheets. Changes made to one will occur in the others.

2. Set the macro recorder to record your actions in one sheet (or write code) and run it for the others. A useful method :-
'-------------------------
For Each ws In Worksheets
' put code here
Next
'--------------------------

Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[scottie1]

Cheers so simple yet so kind