The line below was working great as part of a macro pulling data from another file. The file has changed a few times lately where it is not always the 14 rows that can be deleted eg. this morning it only has 12 rows and the day before 11. What would be needed to have the code go down in column B and once finding the first data then to delete the rows above that eg. delete rows 1-12?