Hi all,
I have a workbook which contains 10 sheets one with application sheet and other is consolidated sheet and the rest is with employees name.where the application sheet contains the VBA form which is used to enter the data in a user friendly mode.the entered data is stored in a consolidated sheet as well as the corresponding sheet with there name.
Now i need the workbook to be shared where everyone can use the worbook and once everyone enter the data it must be saved in consolidated sheet as well as inthere particular sheet.each and everyones data should be saved in consolidated sheet and can be viewd read oly mode by all.
wat is the procedure to do this.
Please help me as i tried doing in a save as method but its not working
I have a workbook which contains 10 sheets one with application sheet and other is consolidated sheet and the rest is with employees name.where the application sheet contains the VBA form which is used to enter the data in a user friendly mode.the entered data is stored in a consolidated sheet as well as the corresponding sheet with there name.
Now i need the workbook to be shared where everyone can use the worbook and once everyone enter the data it must be saved in consolidated sheet as well as inthere particular sheet.each and everyones data should be saved in consolidated sheet and can be viewd read oly mode by all.
wat is the procedure to do this.
Please help me as i tried doing in a save as method but its not working
