Macro to add a row, copy text over a range

[fancybojangles]

Hello! I'm working on a rather hefty spreadsheet in which I need to separate out married couples (currently listed in the same cell), and carry down the Household ID and address information. I don't think there's an easy way to separate out the married couples, but is there a way to select a range of rows to insert a row and copy the data from above down?

Thank you very much!

[tigeravatar]

fancybojangles,

Welcome to the forum!
Are you looking for something like this?

Please Login or Register  to view this content.

[fancybojangles]

Thanks so much, Tiger! It works wonderfully! Hours saved!