Forum Discussion

Dawna Douglas's avatar
Dawna Douglas
Copper Contributor
Apr 30, 2018

Automatic Data

Is there a way for data to automate in the following instance: I input customer number into column B and the customer name automatically populates into column C.
Exel Data
Tomasz Kocur's avatar
Tomasz Kocur
Brass Contributor
Apr 30, 2018

Hi Dawna

 

If you have a list of customers against the number you can use VLOOKUP formula combine with the table gives you nice effect  (see attached file), of course, you can use other function or write your own macro depends on the context of the file.

Dawna Douglas's avatar
Dawna Douglas
Copper Contributor
Apr 30, 2018

I have never used marcos, can you give me example of what formula would look like/

 

  • Tomasz Kocur's avatar
    Tomasz Kocur
    Brass Contributor
    May 02, 2018

    Hi Dawna 

     

    Watch this video to see how to edit and record the macro in a Visual Basic Editor

     

     

    https://support.office.com/en-ie/article/video-edit-a-macro-e2f91363-8bb1-4af2-b9c4-4de04b080bce?ui=en-US&rs=en-IE&ad=IE

     

    In your example for automating the task, you will have to, write a procedure which runs on cells change 

     

    https://support.microsoft.com/en-us/help/213612/how-to-run-a-macro-when-certain-cells-change-in-excel

     

    For writing the macro for you I will have to see the file because there is hundreds way to do that depending on many conditions. 

     

     

     

Resources