jmkbrown

asked on

# Split the data into 2 sheets using VBA

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,

Joan

Thank you in advance,

Joan

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER