Visite Webhosting Latino, el site sobre alojamiento web.
Macro Help/Duplicate Items + Insert Rows + Sum - Mombu the Microsoft Forum
Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Macro Help/Duplicate Items + Insert Rows + Sum
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 29th March 00:31
roberta parker
External User
Posts: 1
Default Macro Help/Duplicate Items + Insert Rows + Sum

I am trying to create a template that will do the
1. Find Duplicate Entries (AlphaNumeric) In A Column
2. Insert 2 Rows Between The Duplicate Entries

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
  Reply With Quote

  sponsored links


Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -