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.
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.