View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
microsoft.news.com[_2_] microsoft.news.com[_2_] is offline
external usenet poster
 
Posts: 8
Default formatting question

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.