Landzir101
Board Regular
- Joined
- Jun 21, 2009
- Messages
- 78
I recently got a macro button up and running that can pull all the data I need for one workbook (9 different sheets) and be placed on the first main sheet. I was wondering how/if you can make a button from one workbook that updates all the others (or at least some of them).
The post is at this link if you wanted a little background..
http://www.mrexcel.com/forum/showthread.php?t=397816
What I have so far is: I have 420 different workbooks that each have buttons in them that update the worksheets in their respective workbooks. I need to update these once a quarter about. I was wanting to set up a MAJOR button that from one master workbook I can click and it goes about updating all the 420 others (or at least a better process than having to go into each workbook separately).
Is this possible? If it is, I am interested to know the key to it (like defining workbooks within the macro button/VBA, etc.) and if any of my code so far would help I would be more than happy to post and work with you guys! Thanks!
The post is at this link if you wanted a little background..
http://www.mrexcel.com/forum/showthread.php?t=397816
What I have so far is: I have 420 different workbooks that each have buttons in them that update the worksheets in their respective workbooks. I need to update these once a quarter about. I was wanting to set up a MAJOR button that from one master workbook I can click and it goes about updating all the 420 others (or at least a better process than having to go into each workbook separately).
Is this possible? If it is, I am interested to know the key to it (like defining workbooks within the macro button/VBA, etc.) and if any of my code so far would help I would be more than happy to post and work with you guys! Thanks!
