NatDeroxL7
New Member
- Joined
- Oct 25, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
Trying to figure out how to get a horizontal daily calendar to fill with information from an open ended table. Basically, I want each employee to simply enter data into the table at the bottom, and the calender will built itself from colum C to the right for 2 years worth of dates.
Test Sheet .xlsx | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | 1-Oct-23 | 2-Oct-23 | 3-Oct-23 | 4-Oct-23 | 5-Oct-23 | 6-Oct-23 | 7-Oct-23 | 8-Oct-23 | 9-Oct-23 | 10-Oct-23 | 11-Oct-23 | 12-Oct-23 | 13-Oct-23 | 14-Oct-23 | 15-Oct-23 | 16-Oct-23 | ||||
2 | A | Conference Start | Conference End | New Computers Start | ||||||||||||||||
3 | Employee hire date | Cost | 5400 | 3400 | ||||||||||||||||
4 | Position | Fund Source | Store A | Store C | ||||||||||||||||
5 | Activity Type | Travel | Purchase | |||||||||||||||||
6 | B | Sales Trip Start | Sales Trip End | |||||||||||||||||
7 | Employee hire date | Cost | 1200 | |||||||||||||||||
8 | Position | Fund Source | Store A | |||||||||||||||||
9 | Activity Type | Travel | ||||||||||||||||||
10 | C | Install Storage Start | Install Storage End | |||||||||||||||||
11 | Employee hire date | Cost | 3400 | |||||||||||||||||
12 | Position | Fund Source | Store B | |||||||||||||||||
13 | Activity Type | Facility Improvement | ||||||||||||||||||
14 | D | Advertising Start | Advertising End | |||||||||||||||||
15 | Employee hire date | Cost | 500 | |||||||||||||||||
16 | Position | Fund Source | Store B | |||||||||||||||||
17 | Activity Type | Purchase | ||||||||||||||||||
18 | ||||||||||||||||||||
19 | ||||||||||||||||||||
20 | ||||||||||||||||||||
21 | Name | Start Date | End Date | Cost | Fund Source | Activity Name | Activity Type | |||||||||||||
22 | A | 1-Oct-23 | 4-Oct-23 | 5400 | Store A | Conference | Travel | |||||||||||||
23 | B | 5-Oct-23 | 10-Oct-23 | 1200 | Store A | Sales Trip | Travel | |||||||||||||
24 | C | 1-Oct-23 | 10-Oct-23 | 3400 | Store B | Install Storage | Facility Improvement | |||||||||||||
25 | A | 9-Oct-23 | 9-Oct-23 | 1200 | Store C | New Computers | Purchase | |||||||||||||
26 | D | 7-Oct-23 | 16-Oct-23 | 500 | Store B | Advertising | Purchase | |||||||||||||
27 | List continutes indefinitely….... | |||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1:R1 | D1 | =C1+1 |