Creating a list of items given a certain condition

[ach5170]

Hello,

I am creating a macros tool that allows users to input new gas wells and their UTM coordinates to see if they require permitting according to a certain law. I am calculating a matrix table that calculate the distance between each well (the wells are listed both horizontally and vertically so that there is a diagonal string of cells containing zero from the top left to bottom right) at the end of the table the I am counting the number of wells w/in a 1/4 mile of each individual well. If there are more than, say 5 for example, within this 1/4 mile, then the well site is 'flagged' for permitting. The final column is 'Permit Triggered?' and goes down the vertical well list listing either 'true' or 'false' for each well.

On the user form I created, I have an option of checking the current wells that require permitting so I want to compile a list of all wells for the user that have 'true' in the last column. I want this list to appear on the user form for the user to see easily and also have the option of printing the list. Do you guys have any ideas that you could explain for me in terms of how I could accomplish this? I am extremely new to VBA so an explaination would be very very helpful. The whole idea of the macros is to make it super easy for the user to add a well and see all the current wells that require permits (have a value of 'true' in the last column) so the worksheet will mostly be running in the background so the user cannot see it. The last column will not stay in the same column, either, as new wells are added/removed the column will change. Thanks for any ideas folks!!!

Happy Friday,
A

[Alf]

I am extremely new to VBA so an explaination would be very very helpful

That evens out I would say as most of the forum members are also new to gas well and UTM coordinates.

So the best way to get help is for you to upload a small workbook with a “raw data” sheet and a sheet showing how you wish your data to be organized.

Alf