the data below is the acutal data coming from the text file. I have a C# app
that is getting the data and populating my excel spread sheet fine. But what
I want is to Group the Make and only see the make once in the spreadsheet
with all the data linked to it instead of seeing multiple lines for the
make.


in my excel file i'm seeing
BMW
BMW
Lexus
VW
BMW
Lexus

and I want
BMW
YEAR MAKE VIN who bought it when they bought it and price

Lexus
YEAR MAKE VIN who bought it when they bought it and price

I dont' want
BMW
BMW
Lexus
BMW
etc.


"David" wrote in message
...
Hi,
If it is coming through s you indicate, only with more lines and vehicles,
it appears you could sort it as it is? The make is the first part of each
line, all the bmws, lexus, etc should group naturally. What have you
attempted so far? It may not be possible to answer your question with out
your specific data in a file. Once it is sorted, you have indicated you
want
more things done? The only thing I see that is consistant and can be
searched
in these strings in the letters "VIN", possibly there is consistancy in
the
spacing? You want at this point to put specific information into columns?

Thanks,

"microsoft.news.com" wrote:

my data in the text file looks like this:

BMW1999 325CI VIN123456789101236JohnSmith 4500020051212
Lexus2004ES300 VIN123456789101236BarneyRubble 2566020051214
BMW2005 325C VIN123456789101236BettySmith 6950020050105

I'm already parsing it out, I just now want to group it by make
"David" wrote in message
...
Hi,
You are going to have to be more specific. What information are you
trying
to link to? What fields will be in the linked files? Does the text file
only
contain the general make of a vehicle? To link to another file you will
need
a unique ID for each text record, like the VIN number to do a lookup to
and
pull specific information. You might be able to set something up on a
FIFO
inventory basis or something similar to that, if all you have is the
general
make.

Thanks,

"microsoft.news.com" wrote:

I'm creating a Excel spreadsheet on the fly using C# with data from a
text
file.
My question is how can I add Groups to the spreadsheet and add some
formatting?

Example:
my text file has cars in it (these can change daily)
BMW
Lexus
VW
GM
Chevy

so in my excel file how can i show
BMW



Lexus



VW


Gm


Chevy

and show information pertaining to that make of car? I have dates,
prices,
etc for each make. I want to group them all together so i don't see
BMW
20
times or VW 20 times, I want to see BMW, VW once and then show all the
data
linked to the make.