+ Reply to Thread
Results 1 to 2 of 2

Macro List that does not belong in it

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Macro List that does not belong in it

    Hi
    Is there like a sub macro to check a department that does not belong in a column A2:A41, C2:C41, E2:E41, G2:G41. These columns are an item number. I did not list the entire columns. Its huge.
    In column B2:B41, D2:D41, F2;F41, H2:H41. These columns where I list the departments. The department that only should list there are 19, 20, 21, 22, 23, 24, 30, 35 and no other than these departments. It randomnly entered but sometimes for some reason there are some department was listed by mistakes.

    So I was thinking that if I click the button for the macro then it will check to see if there are any department that does not belong in columns B2:B41, D2:D41, F2;F41, H2:H41.

    Please help. Thank you.

  2. #2
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Macro List that does not belong in it

    Any luck anyone? :o (

    What I was trying to accomplish is that 19, 20, 21, 22, 23, 24, 30, 35 if its different other than this number it will probably let me know what cells or maybe highlight.

+ 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] Whom does the minimum belong to?
    By drgkt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2019, 06:32 AM
  2. [SOLVED] Determine how many items in a list do not belong to a named range
    By Travisty in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-07-2015, 01:13 AM
  3. Who Belong to What Distribution group
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2012, 06:09 AM
  4. Excel 2007 : How to Link / Belong 2 cells
    By dandi10 in forum Excel General
    Replies: 6
    Last Post: 03-19-2010, 09:30 AM
  5. item belong to that date
    By okl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2009, 08:47 AM
  6. Show all values belong to my value
    By danusko in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-02-2009, 10:05 AM
  7. [SOLVED] Should Method Belong to the Class?
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2005, 05:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1