Mombu the Microsoft Forum sponsored links

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

sponsored links


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


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666