+ Reply to Thread
Results 1 to 2 of 2

List Checking

  1. 05-05-2016, 12:17 PM #1
    jmcdougal
    jmcdougal is offline
    Registered User
    Join Date
    02-01-2013
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    3

    List Checking

    I have 2 columns of data. Col A represents a Part#, Col B represents the quantity of that part number. I'm looking for a way to be able to scan (using a handheld scanner hooked to the PC) the actual part number and enter my quantity and excel check or highlight the corresponding part number in the sheet and tell me if the quantity i entered matches the quantity in the sheet for that specific part number. I also want Excel to keep that formatting to show that i have already audited that specific part number. I think Green should be the color of the matching Part number as well as the quantity IF the quantity entered matches. If it doesn't then it should be Red. Is this possible to accomplish in Excel? Thanks for your help!!!
    Reply With QuoteRegister To Reply
  2. 05-05-2016, 02:03 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: List Checking

    A sample spreadsheet would help a lot. I'll assume you are scanning part numbers into consecutive rows and that somewhere else you have a list of part numbers and quantities. It is too bad you are using Excel 2003. This means some code will have to be used to copy down the conditional formatting. If you were using Excel 2007 or later, you could use Excel tables and this would be automatic.

    We might also want to add some code to position the cursor automatically after each scan.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula:Checking if (A) is in one list, returning Y then checking for (A) in another list
    By vkz7hxy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-11-2015, 01:33 PM
  2. [SOLVED] Checking to see whether a person in one list also exists in another list
    By marketshare in forum Excel General
    Replies: 7
    Last Post: 06-23-2013, 01:12 AM
  3. checking for value within a list
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2011, 05:01 PM
  4. Checking against a list
    By spowell in forum Excel General
    Replies: 1
    Last Post: 04-24-2009, 07:24 PM
  5. list checking
    By ss_bb_24 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-05-2008, 07:40 AM
  6. Checking if different items are in a list
    By LAF in forum Excel General
    Replies: 2
    Last Post: 01-11-2006, 05:47 PM
  7. [SOLVED] Checking if value is in a list
    By roeaster in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2005, 12:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1