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
