Results 1 to 3 of 3

Thread: searching for a specific part# in multiple workbooks.

  1. #1
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0

    searching for a specific part# in multiple workbooks.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm not sure if this should be here or probably in the VBA section.
    Is there an easy way to look for a term, specifically a part#, in multiple files?
    The part# may not be the only information in a specific cell, and may not be in the same range on each sheet.
    I have multiple workbooks, each with 1 sheet.

    I am in need of finding all my files that contain a specific part#.

    So I would like to generate a list of file names if the file contains my part#.

    Thank you,

    Simi

  2. #2
    Neophyte Kelvin Maed's Avatar
    Join Date
    Oct 2012
    Location
    Bristol, United Kingdom, United Kingdom
    Posts
    2
    Articles
    0
    i would use windows search if you are on windows. use the stupid dog to choose in a file, point to a folder containing the term and search

    may only work if file indexing is on.

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    Kelvin, thanks for the response.
    What I actually needed ended up being a lot more complex than just finding the files.

    I was able to accomplish this with some VBA, and manual filtering/sorting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •