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

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

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

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!

"Karin" wrote:

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

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

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

Karin wrote:

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

--

Dave Peterson