chancestrickland
New Member
- Joined
- Nov 4, 2014
- Messages
- 3
So I may not be explaining my issue in the clearest way possible, and this may have been asked and answered before, but here goes. I'll try to use images to communicate better.
Basically, I'm trying to create a time card for my company in Excel. Employees will need to first select a category in the first column. Then, using dependent validation, they'll need to select an option in the "owner" column based on their category selection. I am using a list with the source: =INDIRECT($A$2)
I then create the equivalent validation entries for the cells A3 and B3. When they select a different category, the list will pull from different values.
Naturally, I select A2:B3 and drag down to replicate the cells, expecting the validation source to update to the appropriate cells.
The problem is that the validation source does NOT update with the appropriate cells data. Each cell's data is fixed on =INDIRECT($A$2) or =INDIRECT($B$2).
This obviously creates a problem, as I'd like my employees to be able to add/subtract lines from their time cards as needed.
Can anyone tell me what I'm doing wrong and if there is a better way to address this issue?
Basically, I'm trying to create a time card for my company in Excel. Employees will need to first select a category in the first column. Then, using dependent validation, they'll need to select an option in the "owner" column based on their category selection. I am using a list with the source: =INDIRECT($A$2)
I then create the equivalent validation entries for the cells A3 and B3. When they select a different category, the list will pull from different values.
Naturally, I select A2:B3 and drag down to replicate the cells, expecting the validation source to update to the appropriate cells.
The problem is that the validation source does NOT update with the appropriate cells data. Each cell's data is fixed on =INDIRECT($A$2) or =INDIRECT($B$2).
This obviously creates a problem, as I'd like my employees to be able to add/subtract lines from their time cards as needed.
Can anyone tell me what I'm doing wrong and if there is a better way to address this issue?
