| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I write an Excel macro to pause for data entry then continue? | Excel Discussion (Misc queries) | |||
| Data export from Crystal to Excel | Excel Discussion (Misc queries) | |||
| write macro to input data | New Users to Excel | |||
| Condensing a large data dump | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Hybrid Mode
