Hi all,
I'm sure this question has been asked before but I am looking for some help with setting up data validation.
I have a list of business locations that have a range of allowable cost centres to be used against them.
For example i have purchase invoices in query logged on an excel workbook, one row per invoice. A site and cost centre and manually added for each invoice in separate columns. What i want to do is make the cost centre column a drop down containing allowable cost centre codes for that specific site location based on another worksheet containing that allowable cost centre data.
<tbody>
</tbody>
The allowable cost centre data looks as follows,
<tbody>
</tbody>
Any help or a point in the right direction would be appreciated. Thanks
I'm sure this question has been asked before but I am looking for some help with setting up data validation.
I have a list of business locations that have a range of allowable cost centres to be used against them.
For example i have purchase invoices in query logged on an excel workbook, one row per invoice. A site and cost centre and manually added for each invoice in separate columns. What i want to do is make the cost centre column a drop down containing allowable cost centre codes for that specific site location based on another worksheet containing that allowable cost centre data.
Invoice Num | Site | Cost Centre |
123 | York | 01 |
345 | Leeds | 02 |
678 | Manchester | 01 |
<tbody>
</tbody>
The allowable cost centre data looks as follows,
Site | Name | 01 | 02 | 03 |
YOR | York | Ok | Blocked | Ok |
LEE | Leeds | Blocked | Ok | Ok |
MAN | Manchester | Ok | Blocked | Ok |
<tbody>
</tbody>
Any help or a point in the right direction would be appreciated. Thanks