Macro Help/Duplicate Items + Insert Rows + Sum
I am trying to create a template that will do the
following:
1. Find Duplicate Entries (AlphaNumeric) In A Column
2. Insert 2 Rows Between The Duplicate Entries
Then:
1. Sub-Total(Another Column With Random Numbers) Of The
Duplicate Entries
2. Format the Sub-Total In Bold
I have gotten to the point of writting a macro that will
identify the duplicate entries; does anybody know how to
do the rest? This is a changing set of data, transferred
to excel from a relational database (Lotus123 Rel2, which
contains anywhere between 3000 to 5000 rows. I cannot
spend time grouping the data or manually inserting and
summing.
|