G
Guest
Hi All,
I have a sheet (Sheet#1) formatted something like this:
Saadi
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Sam
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Norman
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Now I want that when on sheet#2, I input any name from this Sheet#1 (e.g.
Saadi, Sam or Norman) in a specific cell, the information given in the cells
next to that name should be displayed.
Like When I enter Sam in that specific cell on Sheet#2 only the
information/data under same name should be populated. Can anybody help me in
this regard? Number of Rows and column are constant for all the Records (5
Rows, 5 Columns)
The name is written in a merged cell (5 columns) above the data cells of
that particular record.
I have a sheet (Sheet#1) formatted something like this:
Saadi
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Sam
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Norman
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open
Now I want that when on sheet#2, I input any name from this Sheet#1 (e.g.
Saadi, Sam or Norman) in a specific cell, the information given in the cells
next to that name should be displayed.
Like When I enter Sam in that specific cell on Sheet#2 only the
information/data under same name should be populated. Can anybody help me in
this regard? Number of Rows and column are constant for all the Records (5
Rows, 5 Columns)
The name is written in a merged cell (5 columns) above the data cells of
that particular record.