Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI disagree with the request to "check the box for First Row Contains Data" - excel files have their headers in the first row, so there is not data there. the only thing this changed for me is I am dealing with the 1st and 7th rows of data instead of 2nd and 8th.
Wow, seems like I should read the notes in the comment box as well as the community article, didnt see it was just sheet one and was assuming it was each sheet (AKA 1, 2 and 3)
Then I read it was only sheet one......
Here's my solution: