Sorting by Team

Hello Excelers ,

I need one of you to help me out with this one?

Attached is a small example of a larger spreadsheet, I print out for each team their areas, so the print area is from column B to column H. I need a formula in B1 to give me the Team name when I filter the list, for example if I sort by Team C, I want "Team C" to be displayed in B1 or sort by Team D, "Team D" to be displayed. Any ideas?

oldchippy

Oldchippy,

I am very happy to share with you a nice j-walk function ...

http://j-walk.com/ss/excel/usertips/tip044.htm

All the Best !!!

Carim

Thanks Carim,

Very impressed with your quick response - 3 minutes not bad!

Cheers

oldchippy

Thanks VBA Noob too

I knew you or Carim would be first to respond

All the best

It is "almost impossible" to beat VBA Noob, who is always complaining about how slow I am ...

Cheers
Carim