I would like to sort a list of geographic sites that contain latitude and longitude information in decimal degrees. The macro would sort a unique list of sites based on a buffer of 100ft within other sites and beside each unique site would contain each other site that falls within 100ft.
I've attached a sample Excel list.
The list will be variable and contain up to 4000 rows of information.
* * *This broadcast message was sent to all bidders on Friday Jun 27, 2008 4:50:17 PM:
The list can be sorted whichever way meaning that if sites A and B are co-located than the first column can be A or B. For example, you can use A in the first column and the colocated site is B OR you can use B in the first column and the co-located site is A.
* * *This broadcast message was sent to all bidders on Friday Jun 27, 2008 5:06:58 PM:
I would also like to make the co-location distance a user defined variable which I've identified in a yellow cell on the input page.