Autofill based on previous table sugestion - Excel VBA

[pedrovrls]

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.


[TABLE="width: 388"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Offer Number[/TD]
[TD]Rev. [/TD]
[TD]Country[/TD]
[TD]Offer
Date[/TD]
[/TR]
[TR]
[TD]45658552[/TD]
[TD]0[/TD]
[TD]Argentina[/TD]
[TD]15/01/19[/TD]
[/TR]
[TR]
[TD]49598652[/TD]
[TD]0[/TD]
[TD]Argentina[/TD]
[TD]15/01/19[/TD]
[/TR]
[TR]
[TD]46450754[/TD]
[TD]0[/TD]
[TD]Chile[/TD]
[TD]15/01/19[/TD]
[/TR]
[TR]
[TD]46613623[/TD]
[TD]0[/TD]
[TD]USA[/TD]
[TD]15/01/19[/TD]
[/TR]
[TR]
[TD]46562203[/TD]
[TD]0[/TD]
[TD]Nigeria[/TD]
[TD]17/01/19[/TD]
[/TR]
[TR]
[TD]46562541[/TD]
[TD]0[/TD]
[TD]Nigeria[/TD]
[TD]20/01/19[/TD]
[/TR]
[TR]
[TD]46339985[/TD]
[TD]0[/TD]
[TD]Venezuela[/TD]
[TD]21/01/19[/TD]
[/TR]
[TR]
[TD]46614652[/TD]
[TD]0[/TD]
[TD]Peru[/TD]
[TD]22/01/19[/TD]
[/TR]
[TR]
[TD]46735584[/TD]
[TD]0[/TD]
[TD]Israel[/TD]
[TD]22/01/19[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help.

Pedro