Barryj
02-12-2006, 08:19 AM
I am trying to get cells populated with data from another sheet when a name is matched.
On sheet 1 I want to be able to type in a name in H9 and if that matches a name in sheet 2 column A then populate sheet 1 D4:U7 with Data from sheet2.
I Have included a file that I hope will help explain what I am trying to achieve.
So what I am basically trying to do is if I typed in Port Kembla into cell H9 on sheet 1 then the data in cells B4:S7 would be placed into cells D4:U7 on sheet 1
On sheet 1 I want to be able to type in a name in H9 and if that matches a name in sheet 2 column A then populate sheet 1 D4:U7 with Data from sheet2.
I Have included a file that I hope will help explain what I am trying to achieve.
So what I am basically trying to do is if I typed in Port Kembla into cell H9 on sheet 1 then the data in cells B4:S7 would be placed into cells D4:U7 on sheet 1