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

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
 
K

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel macro and passwords 3
Formula or macro to analyze data vertical and horizontal? 1
Can I send a doc to group of email addresses via a macro button? 6
Data Form from tables 1
Data export from Crystal to Excel 1
Macro to add data 3
Sum Exported data automatically from Access database 9
excel form. Need data extracted to spreadsheet each time a form co 4

Top