Hello all!

I've attached a sample of my workbook. What I'm trying to accomplish is that on Sheet2 there is a list that I need to find in Sheet1 and then copy all rows associated with this entry. In this case the code is supposed to find the first item (100000) and then copy the row it is in as well as the following 6 and paste to a new sheet. Then do it for the remaining items in the list. I am getting a "subscript out of range" error and I've found that it is because my array "arr2find" is not storing the list from Sheet2. What am I missing or not understanding?!

Any help would be appreciated, thank you

Example.xlsm