Hi Guys
I need to update data from Workbook 1 to Workbook 2 just needing to have the new rows to come across and not duplicating
Workbook 1 looks like this
<tbody>
</tbody>
Workbook 2 looks the same but needs to have the new stock no's added to it each week, so workbook 2 would also need to have stock no a005011, a005012 and a005013 when command button clicked
<tbody>
</tbody>
Thanks
I need to update data from Workbook 1 to Workbook 2 just needing to have the new rows to come across and not duplicating
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 each week, so workbook 2 would also 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