I have a desktop application where I need to fill in results from another source. The source data is present in a DataTable but it’s not sorted in the same way as in the desktop application (I can’t even change the sorting order in the dektop app). I suppose I should use “relative” in some way but not sure how.
I’ve made an illustration to show what I’m after. The figures in the right sheet is to be inputed into the application to the left (column numbers). Please help me!
Hey, unable to view the image. Can you please upload it again.
For each item in the application, Query the Data Table to get the respective value and insert in the application.