Write Macro to Fix Data Alignment (Data dump from Crystal to Excel

  • Thread starter Thread starter Karin
  • Start date Start date
K

Karin

Hi,
I have a crystal report that exports to excel, but it's ugly when it gets
there.
(No other way to get the data)
I need to fix the below data so that the ID sits on the Total Line.
Not every line has the same number of rows between ID and total.
There are 106 IDs.

ID CLIENT
6684991 Client Name
Staff Type 1
Staff Type 2
Staff Type 3
Totals
 
I think maybe I need to do a loop. I can write a macro to copy the id, find
the word total, move back one and paste the id, but how do I get it to do
that until the last row? Thank you!
 
Back
Top