Hello.
I wonder if anyone could possibly help me with a problem.
I have to create a two wage slips for and assignment. I have a database as a seperate sheet (not workbook) with the names of the people, how much they get paid etc. I am having two problems with this.
The first is that I am using Vlookup to get all of the information filled in when you type the persons surname. This part is easy. However I would like to have a list box with all of the names for part-time, than another for full-time (on the other wage slip). How do I do this?
I can only get the full list of names by naming the surname cells "Surname" and going Data|Validation|List, they typing "=surname".
How could I lookup the names and check them against the part-time/full-time column in the same database, then only display the relevant names?
The second problem Is that I have a middle initial box, but some people don't have one, and when I use the lookup function it shows up as "0" for people without one.
I would much appreciate any help you could offer with these problems.
Thanks very much.
P.S If anyone needs the .xls file to help give a better picture I will send it on over
I wonder if anyone could possibly help me with a problem.
I have to create a two wage slips for and assignment. I have a database as a seperate sheet (not workbook) with the names of the people, how much they get paid etc. I am having two problems with this.
The first is that I am using Vlookup to get all of the information filled in when you type the persons surname. This part is easy. However I would like to have a list box with all of the names for part-time, than another for full-time (on the other wage slip). How do I do this?
I can only get the full list of names by naming the surname cells "Surname" and going Data|Validation|List, they typing "=surname".
How could I lookup the names and check them against the part-time/full-time column in the same database, then only display the relevant names?
The second problem Is that I have a middle initial box, but some people don't have one, and when I use the lookup function it shows up as "0" for people without one.
I would much appreciate any help you could offer with these problems.
Thanks very much.
P.S If anyone needs the .xls file to help give a better picture I will send it on over