+ Reply to Thread
Results 1 to 2 of 2

How to make importing matching serial numbers Highlight a line?

  1. #1
    Registered User
    Join Date
    07-10-2019
    Location
    Miami, Florida
    MS-Off Ver
    Office Professional Plus 2013
    Posts
    1

    How to make importing matching serial numbers Highlight a line?

    Looking for some help?

    I have a spread sheet with approximately 500 line entries that include
    (Make, Model, Serial Number, etc..)

    I want to take my monthly list of serial numbers from another source
    and apply them to the current spreadsheet so that the line items would
    automatically light up “yellow” so to be easily recognized.

    I don’t want duplicate entries. I just want to make my monthly report
    serial numbers cause the master report to highlight those lines that match the serial numbers. (Would be nice if I could change the color as well for successive months)

    Any help or ideas would be appreciated.

    Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to make importing matching serial numbers Highlight a line?

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] I need solutions to make serial numbers!
    By veljama in forum Excel General
    Replies: 7
    Last Post: 01-25-2016, 04:10 PM
  2. Highlight numbers with 3 matching digits
    By Jerry HKA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-05-2015, 04:21 AM
  3. [SOLVED] Make serial numbers from Repeating names
    By turist in forum Excel General
    Replies: 2
    Last Post: 04-16-2014, 10:27 AM
  4. Do I need serial numbers to make Date by month columns?
    By KathleenTurnis in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-03-2013, 03:58 PM
  5. Using Match and Index to highlight serial numbers
    By johnmcquay in forum Excel General
    Replies: 1
    Last Post: 05-29-2012, 01:56 PM
  6. matching words and serial numbers
    By allgeef in forum Excel General
    Replies: 4
    Last Post: 03-16-2011, 11:59 PM
  7. Finding a serial number in a list of serial numbers
    By zocoloco in forum Excel General
    Replies: 2
    Last Post: 02-04-2009, 05:20 AM

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