Hi All,
I am working with a spread sheet that needs a bit of automation and insight.
I have team members who have forecasted their hours to work on a particular project thru the calendar year. The columns are spread out as weekends.
this excel sheet is live and can be updated by the members during the course of the month. The logic is lets say today is 2nd October the weekend of 6 October should not be editable in other words as the week progresses the tab for that week must hide. is this possible. can anyone help me with a little bit of concept here.
thanks again
https://docs.google.com/spreadsheet/ccc?key=0AgD23ALrIXLYdFZ1WEdtSFAwWjdvd2xtTk1iVUYyYnc&pli=1#gid=0
I am working with a spread sheet that needs a bit of automation and insight.
I have team members who have forecasted their hours to work on a particular project thru the calendar year. The columns are spread out as weekends.
this excel sheet is live and can be updated by the members during the course of the month. The logic is lets say today is 2nd October the weekend of 6 October should not be editable in other words as the week progresses the tab for that week must hide. is this possible. can anyone help me with a little bit of concept here.
thanks again
https://docs.google.com/spreadsheet/ccc?key=0AgD23ALrIXLYdFZ1WEdtSFAwWjdvd2xtTk1iVUYyYnc&pli=1#gid=0