I have a spreadsheet with sections of data sorted alphabetically by the word (such as "Open", "Closed", "Pending" etc) that's in column F. When the word in column F changes, I have a macro that adds a blank row between them so that the sections are divided. Before each new section of data, I want to do the following:

* Copy the header in row 1 to each of the data sections for ease of reading the data.
* Add row with a title word in Column A above the new header row for each section. This title word should be whatever populates in column F for that section.

How would I do this in a macro?