How to copy a certain row from another sheet to a place on the first sheet

[Gaggie]

i have the following:

sheet aaa.
name number stock
abc 1234 120
ghj 4324 200
ccc 6543 150


sheet bbb.
number boxes start left
1234 12 120 108
6543 50 150 100


Want to have on sheet aaa.
name number stock
abc 1234 120 1234 12 120 108
ghj 4324 200
ccc 6543 150 6543 50 150 100


Pls could somebody help me, is there any vba script to do this.

Thanks Gaggie

 

[Teeroy]

You don't need VBA, this is easily done by formula. Just use the formulas shown below:

aaa

	A	B	C	D	E	F	G
1	name	number	stock
2	abc	1234	120	1234	12	120	108
3	ghj	4324	200
4	ccc	6543	150	6543	50	150	100

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)) E2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,2,FALSE)) F2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,3,FALSE)) G2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,4,FALSE)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


And fill the formulas down.

 

[Gaggie]

You don't need VBA, this is easily done by formula. Just use the formulas shown below:

aaa

	A	B	C	D	E	F	G
1	name	number	stock
2	abc	1234	120	1234	12	120	108
3	ghj	4324	200
4	ccc	6543	150	6543	50	150	100

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)) E2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,2,FALSE)) F2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,3,FALSE)) G2 =IF(ISERROR(VLOOKUP($B2,bbb!$A$2:$D$3,1,FALSE)),"",VLOOKUP($B2,bbb!$A$2:$D$3,4,FALSE)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


And fill the formulas down.

Thanks that works.

 

[Teeroy]

You're welcome.