Hi,
I have many worksheets of data with over thousands and thousands of records.
I am trying to create a macro which will put a bottom border under the entire row of the last duplicate name in column A (creating a visual separation of like records). I would also like the records to have a group number to indicate they are in the same group in column L.
Is there an easy way to do this? The manual process is mind numbing.
I've attached an excel doc to help clarify. I've done two of the example groups manually to show what it is I am trying to accomplish.
Thanks so much in advance. This will really save me eons of time.
wace
Bookmarks