[KLUG Members] Need Spreadsheet Guru

[Rusty Yonkers]

IMHO the best way would be to handle this with a VBA script.  You
would want to parse each line with a read statement.  I am assuming
that you have one customer then the next then the next.  If not sort
the file first by customer number.  Then you could create an array
and then put in the dollar values for each year for the customer then
when you are at the end of that customer write out the line or even
just fill the entire array and write it to the spreadsheet table
whole.  

I have not done this with Excel but with Access.  I am pretty sure
that you could do it in Excel.  The VBA language is pretty
straightforward basic language coding with some extensions to fit it
into the particular program like Excel or PowerPoint.  

> 
> Customer|Year|Sales
> 2|2001|100.00
> 2|2002|50.00
> 2|2003|75.00
> 10|2002|250.00
> 10|2003|375.00
> 15|2001|100.00
> 21|2002|175.00
> 
> and make a spreadsheet that looks like
> 
> Customer|2001|2002|2003
> 
> And fills in years without amounts with zero.
> 
> So far I haven't been able to come up with something.  There must
> be
> some spreedsheet magic I don't know about since I'm sure I've seen
> this
> done.
> 
> I'm using OOO1.1.x, he is using Excel 2000
> 
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 

=====
Rusty Yonkers
CNE, MCP, A+, CCNA, Linux+, Server+, Network+ certified
-----------------------------------------
An Atomic Supergeek with an attitude!
-----------------------------------------
Currently using SuSE 8.2, Mac OS X, and WinXP (would love to get rid of last one)

...............looking for penguin domination.....................

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/