Dear all,
I have the following table and what I want to do is: When I start typing the offer number (or when I finish typing it), the macro automatically copy all the information recovered from the correspondent line previously input in the table.
For example: If it type 45658552,it automatically writes in the column Country Argentina and Offer Date 15/01/19. In addition, it adds one unit in the revision field, getting Rev. 1.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thanks for your help.
Pedro
I have the following table and what I want to do is: When I start typing the offer number (or when I finish typing it), the macro automatically copy all the information recovered from the correspondent line previously input in the table.
For example: If it type 45658552,it automatically writes in the column Country Argentina and Offer Date 15/01/19. In addition, it adds one unit in the revision field, getting Rev. 1.
Offer Number | Rev. | Country | Offer Date |
45658552 | 0 | Argentina | 15/01/19 |
49598652 | 0 | Argentina | 15/01/19 |
46450754 | 0 | Chile | 15/01/19 |
46613623 | 0 | USA | 15/01/19 |
46562203 | 0 | Nigeria | 17/01/19 |
46562541 | 0 | Nigeria | 20/01/19 |
46339985 | 0 | Venezuela | 21/01/19 |
46614652 | 0 | Peru | 22/01/19 |
46735584 | 0 | Israel | 22/01/19 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thanks for your help.
Pedro