First time posting here, so please forgive me if I'm missing info. I'm using Excel 2007 and have a system-produced report that gives PO #'s by line (row). The PO # can be repeated (in column B) several times in the report and I need for the macro to identify the rows with repeating PO's, and when a new PO begins, create a blank row in-between to separate the group and insert a border (bottom) of each group. There is no set number of rows that can appear from this report and no set number of times that a PO will repeat. I hope this makes sense and can provide more info if needed.
Thanks so much!
Angie