Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2015
    Posts
    75
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Post VBA to validate the data

    Hi Experts
    Is it possible to write a code which validates my data for the list of checks? I receive data in haphazard manner and I spend hours to clean the data before using it.
    Regards,
    JD

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    5,331
    Thanks
    19
    Thanked 442 Times in 422 Posts
    If the data is haphazard then automatic cleaning won't work. You need to use a data entry form that requires data in specific formats and validates it on entry, then you can guarantee the data before using it.
    https://support.office.com/en-us/art...3-291fc03e4d77

    cheers, Paul

  3. #3
    Star Lounger
    Join Date
    Feb 2015
    Posts
    75
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Hi Paul
    I mean haphazard means the data is in proper format, but some missing info. I have to check the data in depth manually before working on it.
    Example – I need to match the data set from the data set of last month to check if there is any missing entry available in the current month’s data set. Like small kind of validation of current data set.
    Is there any way to make this process automate?
    Regards,
    JD

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    7,433
    Thanks
    264
    Thanked 1,049 Times in 960 Posts
    J.D.,

    If you could supply some sample data it would make it easier to assess the situation. Are you checking one worksheet against another? If this the case the data can be compared via VBA. HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Tags for this Thread

Posting Permissions

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