Valleymatt
New Member
- Joined
- May 8, 2017
- Messages
- 1
Hi guys, hoping you can help on my first post.
I have about 20 different workbooks (one for each staff member) and they each complete confidential data on these every day. The data then feeds in to a master sheet that only I can see. I have added a button to each individual workbook so that it clears all unlocked cells of data and can be re-used the following day. However, I can only clear the workbooks when I'm satisfied that I have gathered all the required information. I then have to go in to each workbook, enable the macro, clear the data, save and exit. This can be very time consuming. Is it possible to add a button to the master sheet that will 'trigger' the clear data button on all the other workbooks? Any help would be greatly appreciated. Thanks.
VM
I have about 20 different workbooks (one for each staff member) and they each complete confidential data on these every day. The data then feeds in to a master sheet that only I can see. I have added a button to each individual workbook so that it clears all unlocked cells of data and can be re-used the following day. However, I can only clear the workbooks when I'm satisfied that I have gathered all the required information. I then have to go in to each workbook, enable the macro, clear the data, save and exit. This can be very time consuming. Is it possible to add a button to the master sheet that will 'trigger' the clear data button on all the other workbooks? Any help would be greatly appreciated. Thanks.
VM