Macro for sorting stuff in Excel

I have a excel sheet about companys, something like this
company1 www.com1.com pipes
company2 www.com2.com roofs
company3 www.c3.com roofs, walls

And I need a macro that sorts the list by company and it should allways include all the companies, when I've added new ones also. I've tried to do with visual basic, but how can I make it to take all new rows also?

 

is there any particular reason you can't use the sorting menu item already in Excel?

 

I don't have any reason except people just wants it to be a nice little button that they can click...

 

ok.. excel is definately NOT my strong point.. so I give you links..
http://spreadsheets.about.com/od/excelmacrosandvba/ss/blexsortsheets1.htm

 

Hi

Give me a shout and I can sort you out.
ceauke@yahoo.com

Rgds
CE AUKE