How can i create a master worksheet

[Deanobey]

Hello All,

I want to create a master worksheet within a workbook, that if i make any changes too it will update the rest of the worksheets.

Is there a quick and easy way to do this?

Many thanks

[vikas.bhandari]

I have understood from your post, if you enter data to a cell, the same should be entered to every cell. Or if you change the font to a cell, the formatting should be applied to every worksheet. This concept of Slide Master doesn't work with Excel. You can use formulas/macros to get the desired output, but this is not something which Excel can take care of.

HTH,
Vikas