Hi Kevin and All
Thanks for your code, but can you please help me how to apply this code
because my knowledge of using
VB in Excel is zero
Should I
apply this code on the Excel
VB editor or what?? I would be very very
appreciate if you can give me a brief step-by-step guide.....many many
thanks!! :)
Apart from the question I posted in my first thread, I would like to
provide more information about thescenario.
Kevin, yes you are right. These worksheets are linked. A new data
input on those 5 main worksheets will also effect the rest 75
worksheets. Once all worksheets have be updated mannully, all
essential data will be stored onto their My SQL database via Microsoft
Access.
Please anyone give me a brief guide to manage this problem because I am
zero to
VB and Excel
. Thanks in advance!!
Best Regards
Violaplayer
--
Violaplayer
------------------------------------------------------------------------
Violaplayer's Profile:
http://www.excelforum.com/member.php...o&userid=16211
View this thread:
http://www.excelforum.com/showthread...hreadid=276277