Auto Update of Data Cells between Worksheets

[TomV]

HI,

I'm new at doing data copying between multiple sheets.

Is there a way to have a dynamic master sheet and maybe 10 or so sub-sheets with cells that can update from each other between the Sheets ?

Please let me know if this is even Possible. Macros or Formulas?

Thanks !

Tom

[Pete_UK]

Yes, it is possible, using either Macros or Formulas.

You should attach a sample workbook showing a few examples of your master data and a few subsidiary sheets showing what you want to achieve - the FAQ describes how to attach a file to one of your posts.

Hope this helps.

Pete