Here is a sample of a vacation tracker that i have been creating for our site. It is setup in the way it is for our business needs. There is more that will be added to it in the days to come, but i hit a snag with what i am doing.
on the period 1-6 tab all the information is linked to the Employee Information tab. With the people that will be using this file i want to be able to lock out the ENTIRE period 1-6 tab from any type of editing, so no one can mess up formulas, ect. But the biggest problem is when someone takes a day off it can be for many different reasons, not just a vacation day, so a comment is added specifying what it is for (on the Employee information tab).
Now time for my question... Is there a macro that could be built, or an addition to my formula.. Everywhere there is a "1" in the Period 1-6 tab i want it to find the relative cell in the Employee Information tab and copy the comment to that cell.
If its something as easy as changing the formula around to add that in that would be best. but if not is there a macro that could be run everytime the workbook opens to do this?
Hopefully i am clear on what i need, and someone can point me in the right direction.
Thanks
on the period 1-6 tab all the information is linked to the Employee Information tab. With the people that will be using this file i want to be able to lock out the ENTIRE period 1-6 tab from any type of editing, so no one can mess up formulas, ect. But the biggest problem is when someone takes a day off it can be for many different reasons, not just a vacation day, so a comment is added specifying what it is for (on the Employee information tab).
Now time for my question... Is there a macro that could be built, or an addition to my formula.. Everywhere there is a "1" in the Period 1-6 tab i want it to find the relative cell in the Employee Information tab and copy the comment to that cell.
If its something as easy as changing the formula around to add that in that would be best. but if not is there a macro that could be run everytime the workbook opens to do this?
Hopefully i am clear on what i need, and someone can point me in the right direction.
Thanks
Attachments
-
89.4 KB Views: 9