Autofill based on previous table sugestion - Excel VBA

pedrovrls

New Member
Joined
Apr 17, 2019
Messages
2
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.


Offer NumberRev. CountryOffer
Date
456585520Argentina15/01/19
495986520Argentina15/01/19
464507540Chile15/01/19
466136230USA15/01/19
465622030Nigeria17/01/19
465625410Nigeria20/01/19
463399850Venezuela21/01/19
466146520Peru22/01/19
467355840Israel22/01/19

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Thanks for your help.

Pedro
 

Forum statistics

Threads
1,084,989
Messages
5,381,041
Members
401,713
Latest member
BraydenMSB

Some videos you may like

This Week's Hot Topics

Top