Deleting Values Outside of a Range in Two Columns

[JonathanEngr]

I was wondering if anyone might know of a simple way to delete values outside of a range in excel. Here's my situation...

I download point files to create topography in AutoCAD. The files are text files that contain 3 comma separated columns. These columns are Northing, Easting and Elevation, and these three values designate a point on the ground. The files are downloaded from a site online and contain hundreds of thousands of point each, with each file covering 600 acres on the ground. Obviously, this makes for a VERY large surface (topography), and many times I just need a few acre's worth of topo data.

Traditionally, I'll go into a drawing, look at a point to the upper left of my project, write down the northing and easting, then go to the bottom right of my project and do the same. Thus, I'll have a value of say 1086342, 587945 for the upper left, and 1089421, 581125 for the lower right. I need to delete *ALL* of the points in the excel file that are not in the range of 1086342 through 1089421 in the first column ***AND*** 581125 through 587945 in the second column. Right now I sort the first row, then select all rows above and below the range specified. I then sort by the second row and do the same thing. Once that's done, I save the file. It would be terrific if I could use an algorithm where I submit these four numbers and it's done automatically. I have a decent amount of experience with VBA, but I think this is above my skill level. Any help would be appreciated!

[TMS]

Not something I'm familiar with but I'd have thought you could use AutoFilter with two conditions on each column. You might need to copy and paste the stuff you want to another worksheet.

Regards, TMS