Ok, I can't get my head around this problem that I have.
Here goes.
I have a few worksheets within the same workbook. One of the sheets has a list of employee names, addresses, contract etc. The other has the wage slips. I have two sheets for the wage slips, one for full time and the other for part time.
I have managed to name the data within the employee records so its called "employee data". I have then used a validation list to lookup this data. Now its displays the surname of the employee. Once the surname is displayed, I have lookups to get the first name, address, pay etc.
However I have two problems. The first problem is that the validation list shows all of the surnames, part and full time. Is there anyway of only showing one, so you can't select the wrong type?
The second problem is that some people have the same surname, and a validation list will only recognise the first one of the two. How can this work?
I'm not sure if anyone can help but this is out of my league. Any help would be much appreciated.
If I haven't explained properly I can send the workbook over. For a copy of the workbook just reply.
Thanks LOADS!
Here goes.
I have a few worksheets within the same workbook. One of the sheets has a list of employee names, addresses, contract etc. The other has the wage slips. I have two sheets for the wage slips, one for full time and the other for part time.
I have managed to name the data within the employee records so its called "employee data". I have then used a validation list to lookup this data. Now its displays the surname of the employee. Once the surname is displayed, I have lookups to get the first name, address, pay etc.
However I have two problems. The first problem is that the validation list shows all of the surnames, part and full time. Is there anyway of only showing one, so you can't select the wrong type?
The second problem is that some people have the same surname, and a validation list will only recognise the first one of the two. How can this work?
I'm not sure if anyone can help but this is out of my league. Any help would be much appreciated.
If I haven't explained properly I can send the workbook over. For a copy of the workbook just reply.
Thanks LOADS!