+ Reply to Thread
Results 1 to 4 of 4

Macro (UDF) to Return Names of Sheets in Which A Particular Record is not found

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    FL, United States
    MS-Off Ver
    Excel 2007
    Posts
    33

    Post Macro (UDF) to Return Names of Sheets in Which A Particular Record is not found

    Hi everyone!

    I'd like to create a macro(UDF) to return the names of the sheets within a workbook in which a particular record is not found. I'd like it to search all the sheets except for the first 3 sheets (starting from the 4th sheet) as the first 3 are templates for the remaining sheets in the workbook. Basically when I enter a part number on the third sheet of the workbook in a particular cell, I'd like it to scan the remaining sheets (minus first three) to return the names of the sheets that do not contain the record. I'd like it to show up in consecutive cells or a single cell separated by ";" on the third sheet of the workbook (whichever is easier to code). A sample worksheet has been attached. The records I'm referring to begin from the 3rd page within the worksheet, beginning from the "Left/Right Wing Structure" table. Also every aircraft will have it's own sheet and the sheet name will be the aircraft tail number which is why I'd like to return the names of the sheets that don't contain the respective parts. Any help would be greatly appreciated. Thanks!
    Attached Files Attached Files
    Last edited by Hackboss007; 02-18-2014 at 04:07 PM. Reason: Forgot to attach file

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Macro (UDF) to Return Names of Sheets in Which A Particular Record is not found

    Hi Hackboss,

    Take the attached file for a test flight. I provided two solutions (User Interface on Sheet3). The search mechanism is the same in both using the Excel VBA 'Find' command. The difference is the first one ignores the first 3 sheets and the second one allows the user to select 3 sheet names to be ignored.


    If you move the macro to your file, some of the following may have to be changed at the top of module 'ModSearchForItem'.

    If you use the option that ignores the first 3 sheets:
    Please Login or Register  to view this content.
    If you use the option that ignores 3 specific sheet names:
    Please Login or Register  to view this content.

    Lewis
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Macro (UDF) to Return Names of Sheets in Which A Particular Record is not found

    The entire code for the previous post follows:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-13-2014
    Location
    FL, United States
    MS-Off Ver
    Excel 2007
    Posts
    33

    Post Re: Macro (UDF) to Return Names of Sheets in Which A Particular Record is not found

    Hi LJMetzger,

    Thanks a ton for your help. It works great!

    Best wishes,
    Hackboss007
    Last edited by Hackboss007; 03-06-2014 at 04:13 PM.

+ 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. Replies: 4
    Last Post: 05-03-2013, 04:35 PM
  2. [SOLVED] Excel Macro to delete row if one of 37 plus names is found
    By johnny04 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 09-17-2012, 03:24 PM
  3. Simple Macro Help: Google Search Names & Keywords found in Excel Spreadsheet
    By excelbeginnerVBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2012, 04:18 PM
  4. VLOOKUP to look through multiple sheets and return the sheet names
    By ackimbrough in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2011, 03:55 PM
  5. Replies: 3
    Last Post: 04-12-2010, 02:33 AM

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