In A1 I've got drop down list of employees. From C1 I have months as header in 1st row until N1. When i select a employee from the drop down list in A1 the cells from C2 to N2 has to remain blank to enter the data for every month for that employee. When I chose next employee from drop down the cells has to be blank again to enter the data for that respective employee. Such that for every employee in the drop down. Is it possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Drop down and blank cells for entering data
- Thread starter Jonam711
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,540
- Office Version
- 365
- Platform
- Windows
Duplicate to: =IF(COUNTIFS(A2:G2,"X")>1,"Good",INDEX($A$1:$G$1,MATCH("X",A2:G2,0))&" only")
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
Upvote
0
- Status
Similar threads
- Question
