mikenz1983
New Member
- Joined
- Oct 2, 2014
- Messages
- 33
Hi guys
wonder if someone has a solution to the unique one, i currently am working on a sheet with this layout
the list will go on right through to the 31/12/2021 and what this data is, is expected order volumes for an interval.
i want the user on a completely seperate sheet to be able to enter a date in a cell that will then show them the interval data
any ideas ?
wonder if someone has a solution to the unique one, i currently am working on a sheet with this layout
1/01/2021 | ||
| 8am | 5 | |
| 9am | 6 | |
| 10am | 7 | |
| 11am | 8 | |
| 12pm | 9 | |
| 1pm | 10 | |
| 2pm | 5 | |
| 3pm | 7 | |
| 4pm | 2 | |
| 5pm | 3 | |
2/01/2021 | ||
| 8am | 6 | |
| 9am | 5 | |
| 10am | 89 | |
| 11am | 7 | |
| 12pm | 4 | |
| 1pm | 3 | |
| 2pm | 2 | |
| 3pm | 5 | |
| 4pm | 8 | |
| 5pm | 9 |
the list will go on right through to the 31/12/2021 and what this data is, is expected order volumes for an interval.
i want the user on a completely seperate sheet to be able to enter a date in a cell that will then show them the interval data
any ideas ?
