Posts by KDoubleU


    So I am attempting to secure my sheet with some error capture on a certain cell A10, as this is where users are inputting search terms to filter out data to match their term.

    I had a previous error return that would check their entry against every entry in the data sheet to see if there was any match, if not then return an error.

    I am looking to do the same for if there is NO/NULL ENTRY in cell A10. Below is what I have tried but I cant seem to get it working.


    Yep that seems to work a lot better.

    Noticed 1 thing though, I am having to go into the data tab to reset the filter each tome, otherwise it only searches on the filtered down data.

    E.G I search Front, data sheet filters down to only show Front. I reset and then search Blood, doesn't find it as only Front is filtered down still.

    How do I reset the data sheet filter to show all data again on reset?


    That does indeed bring up an error message but seems to do it for any word you enter, even if it has values to return. E.G. I entered front and it returned the error but should instead populate the table and not return an error.



    I have just done a random word search and it returns all of the documents, but they do not include the word inputted, for example "moose" returns all documents.

    How would I go about implementing a fail safe error capture into this to return null or an error when the word inputted is not found.


    That seems to have worked.

    Last thing I am looking to do is remove the columns I - U from the final search outcome.

    I have tried entering .Columns("I:U").EntireColumn.Delete much like the previous row to remove the beginning section from the search results but that doesnt seem to return the correct results.

    How would I achieve this?

    The typo sis in another module.

    Try this

    Thanks Roy,

    That seems to have sorted the search functionality and supplied me with the data required.

    One little tweak that I am also looking to do is to remove rows B, C, D, E and F from the filtered search.

    How would I go about implementing this?


    I am attempting to search the values of Column A on the "data" sheet and return the values from Column A and G Onwards onto Sheet2.

    I have the search function somewhat working as it is returning values that contain the inputted search parameter of Column A but seems to be duplicating when it find the search parameter in another column also.

    Would really appreciate some help to get me the search results I am looking for.