auto fill into rows

[Grahamscown]

in my work book 1 have 5 columns column F is NAME column G is COMPANY column H is MOBILE NO column I is ID NUMBER column J is KEY NO What i am trying to do is when i type in a name into a cell in the name column the other info autofils into the other columns in rows the columns A TO E Will be filled out manually

 

[maabadi]

You can do it with Vlookup or Index & Match Formula.
1. But What about it didn't find Name at Above Cells?
2. Are you have Source Data at another Place (sheet or Range)?

 

[Grahamscown]

You can do it with Vlookup or Index & Match Formula.
1. But What about it didn't find Name at Above Cells?
2. Are you have Source Data at another Place (sheet or Range)?

yes we will have another tab with a sheet containing all the names and info to date and all new ones will be added as they arrive

 

[maabadi]

if this is Source Sheet (Here Sheet1):

Book2
	A	B	C	D	E	F
1	Name	Company	Mobile	Photo ID No.	GMK Key
2	ABC1	AAA	432758683	11245678	16
3	ABC2	BBB	432758684	11357684	14
4	ABC3	CCC	432758685	11469690	25
5	ABC4	DDD	432758686	11581696	38
6	ABC5	EEE	432758687	11693702	no
7	ABC6	FFF	432758688	11805708	56
8	ABC7	GGG	432758689	11917714	98
9	ABC8	HHH	432758690	12029720	34
10	ABC9	III	432758691	12141726	26
11	ABC10	JJJ	432758692	12253732	51
12	ABC11	KKK	432758693	12365738	44
13	ABC12	LLL	432758694	12477744	72
14	ABC13	MMM	432758695	12589750	64
15	ABC14	NNN	432758696	12701756	55
16
Sheet1

You can Use This formula at Cell G2 at Destination sheet ( I suppose it Sheet2) and Drag it down & Right.

Book2
	A	B	C	D	E	F	G	H	I	J	K
1						Name	Company	Mobile	Photo ID No.	GMK Key
2						ABC3	CCC	432758685	11469690	25
3						ABC8	HHH	432758690	12029720	34
4						ABC2	BBB	432758684	11357684	14
5						ABC10	JJJ	432758692	12253732	51
6
7
8
9
10
11
Sheet2

Cell Formulas
Range	Formula
G2:J11	G2	=IFERROR(VLOOKUP($F2,Sheet1!$A:$E,COLUMNS(Sheet2!$F$1:G$1),FALSE),"")

 

[Grahamscown]

if this is Source Sheet (Here Sheet1):

Book2
	A	B	C	D	E	F
1	Name	Company	Mobile	Photo ID No.	GMK Key
2	ABC1	AAA	432758683	11245678	16
3	ABC2	BBB	432758684	11357684	14
4	ABC3	CCC	432758685	11469690	25
5	ABC4	DDD	432758686	11581696	38
6	ABC5	EEE	432758687	11693702	no
7	ABC6	FFF	432758688	11805708	56
8	ABC7	GGG	432758689	11917714	98
9	ABC8	HHH	432758690	12029720	34
10	ABC9	III	432758691	12141726	26
11	ABC10	JJJ	432758692	12253732	51
12	ABC11	KKK	432758693	12365738	44
13	ABC12	LLL	432758694	12477744	72
14	ABC13	MMM	432758695	12589750	64
15	ABC14	NNN	432758696	12701756	55
16
Sheet1

You can Use This formula at Cell G2 at Destination sheet ( I suppose it Sheet2) and Drag it down & Right.

Book2
	A	B	C	D	E	F	G	H	I	J	K
1						Name	Company	Mobile	Photo ID No.	GMK Key
2						ABC3	CCC	432758685	11469690	25
3						ABC8	HHH	432758690	12029720	34
4						ABC2	BBB	432758684	11357684	14
5						ABC10	JJJ	432758692	12253732	51
6
7
8
9
10
11
Sheet2

Cell Formulas
Range	Formula
G2:J11	G2	=IFERROR(VLOOKUP($F2,Sheet1!$A:$E,COLUMNS(Sheet2!$F$1:G$1),FALSE),"")

so if this is done when i type the name the rest of the info will add automaticly

 

[Grahamscown]

so if this is done when i type the name the rest of the info will add automaticly

it does not seem to work

 

[maabadi]

You Should Change Formula source to your Source address & Change Sheet2 at formula to your Sheet name.
Are you Change them?

 

[Grahamscown]

You Should Change Formula source to your Source address & Change Sheet2 at formula to your Sheet name.
Are you Change thsource i have named sheet 1 and the other sheet2if i knew how to upload sheet i would so you can see

 

[maabadi]

Please upload your Example file with XL2BB Addin (Preferable) or Upload at free Hosting Site E.g. GoogleDrive, OneDrive, www.dropbox.com or ... & Inert Link Here

 

[Grahamscown]

Please upload your Example file with XL2BB Addin (Preferable) or Upload at free Hosting Site E.g. GoogleDrive, OneDrive, www.dropbox.com or ... & Inert Link Here