Forum Discussion
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.
3 Replies
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.
I have never used marcos, can you give me example of what formula would look like/
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.
