hi, i have a workbook with two sheets (sheet1 and sheet2).
Sheet 1 has the First Name, Last Name and Location of each user.
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]Paul[/TD]
[TD]Allen[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD]Chicago[/TD]
[/TR]
[TR]
[TD]Alan[/TD]
[TD]Baretto[/TD]
[TD]Los Angeles[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 only got First Name and Last Name. There can be multiple names of same user.
I need to populate location for each user
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know the best way to populate location for each user in sheet2.
thanks
NT
Sheet 1 has the First Name, Last Name and Location of each user.
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]Paul[/TD]
[TD]Allen[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD]Chicago[/TD]
[/TR]
[TR]
[TD]Alan[/TD]
[TD]Baretto[/TD]
[TD]Los Angeles[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 only got First Name and Last Name. There can be multiple names of same user.
I need to populate location for each user
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alan [/TD]
[TD]Baretto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Whitney[/TD]
[TD]Campbell[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know the best way to populate location for each user in sheet2.
thanks
NT