Aug 04 2020 05:56 AM
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 able to automatically collect the data of the following from another workbook.
a. Part Number
b JT Quantity
on enclosed picture the process details should be populated on the process column on the other excel workbook.
Aug 04 2020 06:22 AM
Aug 04 2020 11:11 PM
@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.