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
<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
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