+ Reply to Thread
Results 1 to 2 of 2

User entry of spaces cause incorrect data being pulled

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    Tampa, Florida
    MS-Off Ver
    MS Office 365
    Posts
    46

    User entry of spaces cause incorrect data being pulled

    I use the code below to perform filters with my data. For example, one of the filters in red below calls for anyone with a job title of "Dist Line Tech." Unfortunately, sometimes users enter a space before or after the entry. In these cases it will not work correctly and pull the correct data. Is there anyway I can re-code this so if someone inadvertently enters a space the correct data is still pulled? Many thanks.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: User entry of spaces cause incorrect data being pulled

    use asterisk
    Please Login or Register  to view this content.
    However, if your users are not disciplined in their entry that implies your data will inherently be unreliable (they might misspell the words etc?)... maybe you should just have data validation where they enter the data?
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. [SOLVED] Incorrect Formatting Applied to Data from User Form to Worksheet
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-16-2020, 04:58 PM
  2. Highlight A Textbox For User Reentry After Incorrect Entry
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2018, 01:18 PM
  3. Replies: 5
    Last Post: 08-04-2015, 12:09 PM
  4. [SOLVED] Macro to Group Part #s Together than Identify Those Pulled from Incorrect Bins
    By mab1284 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 09:54 AM
  5. [SOLVED] Vlookup throwing incorrect value when pulled up
    By smvsiyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2014, 01:54 AM
  6. [SOLVED] sheet1 row with spaces between cells, pulled to sheet2 column with no spaces between cells
    By chestersneakers7 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-18-2013, 05:56 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