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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,089,995
Messages
5,411,735
Members
403,394
Latest member
Mohan Kumar

This Week's Hot Topics

Top