Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |