RE: [PcTech] Excel ?

["Scott Johnson" <sjohnson@xxxxxxxxxxxxx>]

Where is the data coming from?  Is the data refreshed alot to keep it current?

I have created Excel spreadsheets that use VBA to 'download' data from the
iSeries and put it into the spreadsheet.  Doing it this way, you can format the
stuff going into the cells anyway you want.  What you are asking for I have done
it two different ways.  The way you want and the way shown below.  The only
problem with either way is that sorting in Excel is no longer feasible.

If you want to get REALLY creative, you could put a print button on the
spreadsheet that calls a VBA routine that creates a new worksheet, formats it
the way you want, prints that worksheet, and then deletes the worksheet.  Many
options are possible if you are willing to dive into the world of VBA.

-- Scott

---------------
| AAAA | 1234 |
|      | 5678 |
|      | 2222 |
|      | 5874 |
---------------
| BBBB | 1234 |
|      | 5678 |
---------------



> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx
> [mailto:pctech-bounces@xxxxxxxxxxxx]On
> Behalf Of Mark Allen
> Sent: Thursday, August 21, 2003 10:12 AM
> To: 'PC Technical Discussion for iSeries Users'
> Subject: [PcTech] Excel ?
>
> Is there a way to do this in Excel?
>       Col 1   Col 2
> Row 1 AAAA    1234
> Row 2 AAAA    5678
> Row 3 AAAA    2222
> Row 4 AAAA    5874
> Row 5 BBBB    1234
> Row 6 BBBB    5678
>
> What I want is when it prints to show like this
>
>       Col 1   Col 2
> Row 1 AAAA    1234
> Row 2         5678
> Row 3         2222
> Row 4         5874
> Row 5 BBBB    1234
> Row 6         5678
>
> i.e. if Col A has same value as the row above it don't
> print/make blank
> Col A
>