i want to learn how to use excel again, i have Office 2010.
As i have no other ideas to do work on. i thought i could automate my Bosses Work Plan for the Team.
I've attached a link to the sheet, so you can see what i'm talking about
www.smogsy.co.uk/planner.xlsx
i would like some tips on best way do to do the following or code examples if possible.
What i want to do is:
1. select the Month in A3 and the Dates be added into B3 -AI & day to the row below (low priority)
2. id like to add an extra row after each person to show/hide comments on the project with a button however each person could have more Rows or less rows so not sure how to make sure it hides/shows the right row?
thanks for the help
ill add more questions once i figure out what else i need
As i have no other ideas to do work on. i thought i could automate my Bosses Work Plan for the Team.
I've attached a link to the sheet, so you can see what i'm talking about
www.smogsy.co.uk/planner.xlsx
i would like some tips on best way do to do the following or code examples if possible.
What i want to do is:
1. select the Month in A3 and the Dates be added into B3 -AI & day to the row below (low priority)
2. id like to add an extra row after each person to show/hide comments on the project with a button however each person could have more Rows or less rows so not sure how to make sure it hides/shows the right row?
thanks for the help
ill add more questions once i figure out what else i need