I have a file that is exported to excel from another application. It contains monthly budget variance reports from multiple cost centers. However, the department name and description appears at the bottom of each report instead of at the top of the report, and there are no page breaks between departments.

I would like to write a macro to move the row containing the department name and description from the bottom of the selection to the top. Every report has a different amount of rows but there are some consistent patterns. For example, the department and description always starts with 6 numbers followed by a space followed by the description. At the very beginning of the report, the header is 4 rows, row 5 is blank and a differing number of rows (i.e., 1-5 rows) before the first line item of the first department. The end of each department's report always has the description "Productive Manhours per Stat", followed by 2 blank rows, followed by the department name and description (the item I want to appear at the beginning of each section of data). After the department name and description, there are differing amounts of blank rows before the next department's first line item appears. There are always 13 columns.

I realize this may be vague but I have to start somewhere, and I've spent a lot of time trying to figure something out. Can anyone help?