Each day I will be getting a spreadsheet that will need to be split into to 2. I will know where the data needs to be split by finding "HHP0" in column A. I will not want to copy of the first 2 rows. The data above the row that contains "HHP0" will go to one sheet, while the data below "HHP0" will go to another sheet. I am able to find the data and select all of the information above that row, but I don't know how to exclude the top 2 rows.
Thank you in advance,