I want to get only a section of a excel worksheet, but the starting and ending point is different for different files as the line of items differs. I found the row index of the start and end point by looking for the word “JBP” and “JBP total”. How do i get the in between information and put it in another new worksheet?
note: there are merged rows, so the row index i got is not exactly the cell number in excel. They count merged cell eg. 11 + 12 as one
Thanks in advance!