ebilbrough
Board Regular
- Joined
- Nov 17, 2010
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
In cell A2 I have a date that represents the start date of an activity.
In cells A3 thru A5 I have the values 6, 7 & 6.5
Cells AA1 thru AA30 are date headers for the month.
I want to be able to have the values 6, 7 & 6.5 auto populated into the cells represented by the start date in cell A2.
Example: cell A2 value is "21 JUN"; cell AA21 contains the value "21 JUN". I want cells AB21, AB22 & AB23 auto populated with the values 6, 7 & 6.5 when the value in cell A2 is updated.
Many thanks.
In cells A3 thru A5 I have the values 6, 7 & 6.5
Cells AA1 thru AA30 are date headers for the month.
I want to be able to have the values 6, 7 & 6.5 auto populated into the cells represented by the start date in cell A2.
Example: cell A2 value is "21 JUN"; cell AA21 contains the value "21 JUN". I want cells AB21, AB22 & AB23 auto populated with the values 6, 7 & 6.5 when the value in cell A2 is updated.
Many thanks.
