Master List.

[MartinMax]

Can someone guide me in the right direction: I have a master List that has 5 columns the uniqueness of one of the columns is that it is the SS Number, what I like to do is this: If I type the SS No. in a New workbook or a new sheet, is it possible to auto fill the whole row to the left and right with that information that belongs to that particular individual from that master list?. If so can you please help me on how to go about doing it.

Thanks so much for your time.

 

[etaf]

you can use index/match

you will need to specify the full path for a workbook and sheetname

assuming the columns are in sheet1 and you want to copy to sheet2

assuming columns are A,B,D,E,F
and the SS value is in Column D

in sheet2 you type SS value in A
to pull back A

=index(sheet1:A:A, match(a2,sheet1:D:D,0))
column B
=index(sheet1:B:B, match(a2,sheet1:D:D,0))
column C
=index(sheet1:C:C, match(a2,sheet1:D:D,0))
etc