Hi,
My VBA is more than a tad rusty and I'm looking for some help. I have data files that represent 2d maps of tree locations with trees in grid pattern. The maps are of varying shapes and run to around 25000 trees each with a row column and family number as well as up to twenty more fields for various measurements. I would like to be able to sort the data file according to the following options. The first and most importantly by a variable number of rows serpentining back and forth across the columns
This is how the sort should look after the sort according to the first few lines of the data set. The overall shape changes from site to site, so the number of rows and columns will be different for each. Ideally I will also be able to choose either ascending or descending.. Any suggestions?
Thanks
Jake
My VBA is more than a tad rusty and I'm looking for some help. I have data files that represent 2d maps of tree locations with trees in grid pattern. The maps are of varying shapes and run to around 25000 trees each with a row column and family number as well as up to twenty more fields for various measurements. I would like to be able to sort the data file according to the following options. The first and most importantly by a variable number of rows serpentining back and forth across the columns
This is how the sort should look after the sort according to the first few lines of the data set. The overall shape changes from site to site, so the number of rows and columns will be different for each. Ideally I will also be able to choose either ascending or descending.. Any suggestions?
Thanks
Jake