Excel VBA/VBE need help....

[anthonyh]

Currenty I have a workbook that consiist of 15 sheets, my goal is to b
cale to update all date when I replace the existiong master sheet s
all sub sheets can update as well. I'm new to this application bu
from researching I feel it can be a handy tool if I can just pick it u
and learn it. Any sujestions on where to start?

Thanks,

Ton

 

[Gary''s Student]

Hi Tony:

If your all your derived sheets have links to the master sheet, then I
suggest that you do not delete and replace the master sheet.

Instead, clear all the cells in the master and replace them with new values.
That way the links in the derived sheets will continue to work.