dt.Rows(3).Item(dt.Columns.Cast(of datacolumn).where(function(col) col.columnname.tostring.tolower.trim.contains(“2021”) and col.columnname.tostring.tolower.trim.contains(“february”) and col.columnname.tostring.tolower.trim.contains(“operational availability”))(0))
It is a work to put together a list of data that has been processed and confirmed externally.the data processed externally,there are multiple production lines such as No3Line and No12Line, so there are also multiple data. Even if the data is the same as February 2021, it will be multiple data because there are multiple production lines. Of course, if you connect the row number to each production line, you can paste the data in each cell, but I’m looking for a method that I think there is a way to paste it without connecting the row number in advance. I did. The method of getting the column name was very helpful. thank you. If you can’t find a method, we will process by associating the line number with each production line, so there is no problem. Sorry for the inconvenience.