Excel VBA/VBE need help....
 

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

Thanks,

Tony


--
anthonyh
------------------------------------------------------------------------
anthonyh's Profile: http://www.excelforum.com/member.php...o&userid=29322
View this thread: http://www.excelforum.com/showthread...hreadid=490410

Excel VBA/VBE need help....
 

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.
--
Gary's Student


"anthonyh" wrote:


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

Thanks,

Tony


--
anthonyh
------------------------------------------------------------------------
anthonyh's Profile: http://www.excelforum.com/member.php...o&userid=29322
View this thread: http://www.excelforum.com/showthread...hreadid=490410