Hi,

I am not sure where else to ask but this seems like the place.

My job uses Office 2000. Let the groaning commence. What I am trying to do
is create a Macro in Excel 2000 that duplicates what a macro in SAS does?

The macro in SAS takes the Longitude and Latitude for a business, goes
through a list of all our store location long and lat and figures the
distance, then keeps the minimun distance.

There are about 1020 Store locations. The number of Business is currently
10 though that number could change depending on sales.

SAS works great for things like this. The idea is to get it into Excel and
then let the department requesting the information do it on their own.

Any advice would be greatly.

Thanks
Christian Falde