Multiple sheets updating one Master

[brouhaha501]

I am almost done with the programming on this sheet, and this site has been so so helpful, but i have one last final problem. Each person in my office will have a copy of the sheet attached to this post, located on their desktop. What i need to happen is when they hit close on the Main menu, it will automatically send the information to a master sheet, then close the workbook. the master sheet will be reviewed by the managers for accuracy.

For one, I'm not even sure how I would need to code this. Second, I know that, because Sheet 4(labeled as sheet1) will be protected, will that affect saving the information onto another workbook? And, the third, if possible, I would like the managers to be able to edit the information that comes in from multiple sheets, and have that update the corresponding sheet.

I understand that the last part may not be possible, but if it is, it would help greatly.

the username to use is tester, and the password is test01

[brouhaha501]

I found code that may help, but it will not copy the information to the selected sheet. right now, I have the collated sheet labeled as Book.xlsm. all the sheets for right now are located at j:\My Documents\edi\blank templates\TAD report. Also, right now it's setup in a Macro. Is there any way that I can add this code to a command button on a userform? I want to make it so when the associate closes the sheet, that it will automatically update the collated form. Could you help in what I am doing wrong. thanks again for all of your help

Please Login or Register  to view this content.