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

[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

 

[Karin]

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!

 

[Dave Peterson]

I'd put it on all the lines in between, too.

If that's ok...

Debra Dalgleish shares some techniques:

http://contextures.com/xlDataEntry02.html
http://www.contextures.com/xlVideos01.html#FillBlanks