I've scoured Mr. Excel for a scenario similar to mine ... but with no success. I need some guidance on making a calendar autofill certain information ... but each year obviously the calendar is going to change.
Here's a partial image of my spreadsheet (hopefully it turned out). More explanation of what I'm after follows this html code.
Okay ...
In Column A (from row 5 - 93) a person enters a two letter Code: (CO, LV, PD, ED, etc) In Columns B and D a person enters the START and END dates of a vacation.
What I would "LOVE" is for the appropriate cells on the calendar to fill in automatically with the two-letter code that was provided in Column A (next to the dates). Does this make sense? I've given an example with the image (if it turns out) And obviously if the dates are removed, I would need the pre-fills within the calendar to remove automatically also.
What troubles me most is that the first month's cell (E1) is a variable. So whatever date you change that to, the rest of the year will follow. So I want to avoid a system where it works this year .. but is broke the next
I only know the basics of Excel as I've only used it a few months. So I really need some friendly guidance here.
Thanks to all.
Kevin.
Here's a partial image of my spreadsheet (hopefully it turned out). More explanation of what I'm after follows this html code.
| TEST HOURLY Vacation.xls | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 3 | EmployeeNumber:XXXXXX | October2006 | |||||||||||
| 4 | Start | End | Total | ||||||||||
| 5 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | ||||||
| 6 | LV | 10/2/06 | 10/3/06 | 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| 7 | PH | 10/10/06 | 10/10/06 | 0.5 | LV | LV | |||||||
| 8 | HE | 10/12/06 | 10/12/06 | 2Hrs | 8 | 9 | 10 | 11 | 12 | 13 | 14 | ||
| 9 | PH | HE | |||||||||||
Hesse | |||||||||||||
Okay ...
In Column A (from row 5 - 93) a person enters a two letter Code: (CO, LV, PD, ED, etc) In Columns B and D a person enters the START and END dates of a vacation.
What I would "LOVE" is for the appropriate cells on the calendar to fill in automatically with the two-letter code that was provided in Column A (next to the dates). Does this make sense? I've given an example with the image (if it turns out) And obviously if the dates are removed, I would need the pre-fills within the calendar to remove automatically also.
What troubles me most is that the first month's cell (E1) is a variable. So whatever date you change that to, the rest of the year will follow. So I want to avoid a system where it works this year .. but is broke the next
I only know the basics of Excel as I've only used it a few months. So I really need some friendly guidance here.
Thanks to all.
Kevin.
