Forum Discussion
Automate data entry from another workbook
Please help me, i want to automate a task in excel but i don't know how to do it since data extraction is complicated. Here's what needs to be done: 1. When i enter the JT number excel should be ...
jobelledimaano , if you need a non-macro solution, Power Query can do what you are looking for. You would load the details from your Master file into the working file using PQ and use it for lookup purposes.