I have an Excel file that I’m looking to copy the values from one sheet to another based on the data between rows.
I started off by reading the Range of the Excel file and then creating a condition IF statement. But this is where I’m not entirely sure what would go next. My IF statement is: dt.Rows.ToString = “Header1”, Then Read Row. But I’m not sure how I would read the rows up until the next header labeled Header2.
I’ve attached a sample Excel document that shows what I’m trying to do.
Thanks.sample.xlsx (9.4 KB)