I have an excel sheet that is created once a week from a reporting system. It will always look like below screenshot (Headers start on cell B6 and the row count will be different each time. The columns will always be the same.).
What I need to do is grab only the information in the table, including the headers and copy it to another worksheet. The last row will always contain the “grand totals”. I do not need the title “Sales Reports” nor the “selection criteria” row. How would I get only the data and the headers?