+ Reply to Thread
Results 1 to 8 of 8

Edditing a script for filtering results

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    North Dakota, US
    MS-Off Ver
    Excel 2010
    Posts
    19

    Edditing a script for filtering results

    I have a script here that helps me sort through thousands of land records...cool beans.. but a lot of time the script messes up when there are blank entrys that are out of its programmed parameters.


    Here (below) is how it should look



    Section Township Range
    2 146 95
    3 145 92
    4 145 95
    5 144 96
    5 144 96


    But sadly many people fill in the entrys on the web tables wrong or whatever the case may be and it will mess me all up, Im hoping to add another clause to the script that will disregard these bad entrys so i can just carry on.

    Here uploaded is my script with pulled data that im talking about that will mess up when i run the script.

    On the row with the LEGAL info is basically the geographical location data i need, the script will sort it but as you can see in the 6th entry its blank, and sometimes they put other random info in it such as Legal: subdivision anderson , lot 4, row 4 or whatever. If the Legal row has no township range section I want to disregard it and keep filtering

    If theres any coding that i can add please help me!!!


    FullPGscript.xlsm

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Edditing a script for filtering results

    hi mattr11992, option, please check attachment, press Run button or run code "test"
    I hope I understood your request correctly
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-31-2014
    Location
    North Dakota, US
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Edditing a script for filtering results

    that actually works pretty good, SPASIBO! how can i not have the results separate?

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Edditing a script for filtering results

    please check attachment
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-31-2014
    Location
    North Dakota, US
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Edditing a script for filtering results

    ok, that didnt change anything did it?

    Section Township Range
    29 158 98
    11 156 95
    12 156 95
    1 156 95
    28 157 95
    32 159 95
    27 157 95
    13 156 95
    14 156 95
    28 156 99
    15 159 95
    3 159 100


    this is how i would like the data, no duplicates, on the script you wrote it seems like i had more results than i should? 100 entrys but there was 450+results?

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Edditing a script for filtering results

    it did change, it was reply to your post: how can i not have the results separate?
    The data has no empty rows between the blocks.

    Duplicates out is firstly mentioned.

  7. #7
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Edditing a script for filtering results

    is it duplicates within one Legal record or the whole data that you need out?

  8. #8
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Edditing a script for filtering results

    no duplicates on the whole data
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Script to have your form check the contents of a cell and reply different results
    By steve_from_the_uk in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-05-2014, 03:35 PM
  2. How do I write a script for + or - results
    By rbaron in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2012, 10:02 AM
  3. Same script running in two workbooks with different results.
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2008, 03:06 PM
  4. Help to modify VBA script so it displays results in other sheet ce
    By Calle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2006, 10:20 AM
  5. Need script for filtering data
    By FUZION in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2006, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1