Excel VBA/VBE need help....

  • Thread starter Thread starter anthonyh
  • Start date Start date
A

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
 
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.
 
Back
Top