Aussie Grid
New Member
- Joined
- Jan 14, 2010
- Messages
- 47
I need to select the intersecting cell of 2 values.
A2:A10 = Staff names
B2:B10 = Dates (in 1 cell merged from 3)
Thus select the intersection of eg. James and 1/2/12
All cells formatted as text, except the dates which are dd mmm.
I intend to create a form that will enter data in the intersected cell as determined by 2 combos, 1 for staff and the other for dates.
Any & all help appreciated
Aussie Grid
A2:A10 = Staff names
B2:B10 = Dates (in 1 cell merged from 3)
Thus select the intersection of eg. James and 1/2/12
All cells formatted as text, except the dates which are dd mmm.
I intend to create a form that will enter data in the intersected cell as determined by 2 combos, 1 for staff and the other for dates.
Any & all help appreciated
Aussie Grid