Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
test_servey.xlsm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
5 | Wing | Floor | Desk | Dock | USB3 | K/B | Mouse | Monitor | HDMI/DVI | DVI/DVI | Note / Comments | Date | ||
6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Full Kit | ||||||
7 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | No Kit | ||||||
8 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | Part Kit | ||||||
Site Survey |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
K6:K8 | List | =DropDown!$A$2:$A$4 |
Good evening,
I have 3 issues:-
1) in the cells that have 1 or a 2, i want to force the user only to use 1 or 2 in the respective area (d6-j999 .and should the user not use 1 or 2 in the respective cells, a popup message will appear stating the fact .
2+3) in the date which MUST be entered when , can the date be triggered so when there is data in the range k6-k999.
I cannot use ()now as it will change the date each each day. So can it be done so the date will automatically enter, but not change when the 'system' date does?
The above is well out of my scope & therefore reaching out to Mr Excel for help.
Thank you for your assistance with my issue.
Last edited: