How to read next column

I need to put the highlighted values from Excel into the First Data Screen, on the right. The order it will need to be: Loan Number (cardholder nmbr), Amount, Date (Trdt). I would need to do this 3 more times after this first time, for the other columns. The columns would stay the same, but the rows would vary. Would this be possible? I could also try to put H – K on a different worksheet if that would be easier to work with. I am not sure how to extract only the highlighted information and put it in first data. I have tried a few things and nothing seems to work. Any suggestions?

You can read the excel file with headers into a datatable. Next you filter your datatable using a dataview to a table with the wanted columns.
With a where linq query you can eliminate empty rows.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.