SORTING

[lehigh]

Hi All

I have a company worksheet
Column A has a company id number and column B is a lookup from column
A to another workbook to provide a company name.

I tired sorting the name field but nothing changed position. (no they
are not already in alpha order)

Is this because column B is a formula?

Is there a work around?


Thanks for your help.

Tom Snyder