Recent content by Ross_curtis

  1. R

    Formatting help.

    Hi, Firstly I know very little about VBA so please bear with me and excuse my ignorance. hopefully what I need to do is fairly simple. I have a macro with various drop downs, from these drop downs I select a column heading IE J. I do this for various items in an Excel sheet. Once all the...
  2. R

    Filtering "is not null" returns null values !!

    The reason I'd want to is that I seem to have a mixture of Null and empty - for some reason. I'll give that a go, thanks. Having said that using <>"" as a search seems to work perfectly so I should be able to live with it.
  3. R

    Filtering "is not null" returns null values !!

    Thanks for the tips. It certainly makes sense. Should I want to convert a null field to a empty field and visa versa how would I go about that?
  4. R

    Filtering "is not null" returns null values !!

    Both are text.
  5. R

    Filtering "is not null" returns null values !!

    I have a table which has been imported from several Excel sheets, in total I have approx 142000 records. One of the columns is status - which I am trying to base a filter on. IE filter all Status 1's, then I need to find which records have a value in a the payroll column. From my limited...
See more
Back
Top Bottom