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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,090,491
Messages
5,414,853
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top