Excel VBA Vlookup

[mack22]

Hi Guys
I am wanting to copy rows of data from one workbook to another based on a value.

Workbook1 has a list of car parts from vehicles/stock no

stock no	model name	year model	part name
a005013	911	2003	rear spoiler
a005013	911	2003	wiper motor
a005055	911	2005	drivers airbag
a005055	911	2005	driveshaft

<tbody>
</tbody>

Workbook2 needs to lookup the parts from workbook1 and copy the rows into workbook2 using a command button based on the stock no
so if stock no a005055 was entered it would copy 2 rows into workbook2.

Hope this makes!!
Many thanks

 

[mack22]

I have another question for you I would also like to update data from Workbook 1 to Workbook 2 without duplicating it.
Workbook 1 looks like this

stock no	model name	year model
a005013	911	2003
a005012	911	2003
a005011	911	2005
a005010	911	2005

<tbody>
</tbody>

Workbook 2 looks the same but needs to have the new stock no's added to it, so workbook 2 would need to have stock no a005011, a005012 and a005013 when command button clicked

stock no	model name	year model
a005010	911	2005
a005009	911	2003

<tbody>
</tbody>

Thanks again

 

[My Aswer Is This]

I have another question for you I would also like to update data from Workbook 1 to Workbook 2 without duplicating it.
Workbook 1 looks like this

stock no	model name	year model
a005013	911	2003
a005012	911	2003
a005011	911	2005
a005010	911	2005

<tbody>
</tbody>

Workbook 2 looks the same but needs to have the new stock no's added to it, so workbook 2 would need to have stock no a005011, a005012 and a005013 when command button clicked

stock no	model name	year model
a005010	911	2005
a005009	911	2003

<tbody>
</tbody>

Thanks again

You need to start a new posting for this question.