Hi Guys,
Thanks in advance for your help.
I am trying to create a spreadsheet which allows different teams to input their data on their individual sheets, and which then aggregates all the teams data onto a general sheet for all the group. The idea is that each user will only be able to see his specific team sheet and the general sheet, but not other teams sheets. The line manager should be able to see all the team sheet and the general sheet.
I thought about the following:
Create a Number of team sheets namely for the teams CORPORATES, FINANTIALS, COVERED, ILLIQUIDS. Automatically hide these sheets so that they cannot be unhidden manually. These sheets will contain the individual team information.
Create a Master sheet, with a number of buttons, namely CORPORATES, FINANTIALS, COVERED, ILLIQUIDS. Upon clicking these, the system will check if the username corresponds to a valid username for that team, and if so will unhide that particular team's sheet.
Create a summary sheet which feeds from all the team sheets and adds them up. Everyone should be able to see this sheet, but only one username, the manager, can edit it.
Any Ideas? I have programmed in C before, but I am quite new with VBA and Macros, so any help or Code that you can give me will be great!
Thanks forum!
Jaime
Bookmarks