+ Reply to Thread
Results 1 to 3 of 3

Windows Search - Multiple Excel Files - Checked Box Search

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Question Windows Search - Multiple Excel Files - Checked Box Search

    So I have 300+ excel reports (years worth) that I have to go through to create of list. This list is for only a specific type of report. We sort our reports by having three seperate boxes that could be checked. They are "Internal, External, R&D". I am looking for R&D reports only. This value is in the same location for all reports, which is in cell H5, Check Box 48.

    Example.png

    My question is this... Is there a windows command I can type into the folder search (file contents) where I can get a search list for all files that have the R&D box checked? Or do I have to manually open every one to find out which one it is? Or is there another way to search for this that I have no idea about?

    Thanks!
    -Sirolk99

  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,917

    Re: Windows Search - Multiple Excel Files - Checked Box Search

    Hi, welcome to the forum

    You neglected to say if these reports are all in different folders, different files, or different worksheets?
    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

  3. #3
    Registered User
    Join Date
    02-21-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Windows Search - Multiple Excel Files - Checked Box Search

    They are in a master folder, which then has subfolders for each individual year, and inside the individual year folder there are the individual reports. All the reports are all just a edited/modified copy of a blank worksheet template.

+ 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. How to start a Windows Search using VBA and how to get results of the search
    By Torix31fr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2014, 11:40 AM
  2. Search through multiple excel files and get data
    By klunker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 08:29 AM
  3. Search for a string in multiple excel files with multiple sheets
    By ghermanu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 05:46 PM
  4. Replies: 1
    Last Post: 06-05-2012, 01:39 PM
  5. Replies: 6
    Last Post: 03-08-2011, 04:08 AM
  6. How to Search content of Multiple Excel Files?
    By camrencrew in forum Excel General
    Replies: 1
    Last Post: 04-07-2010, 03:38 PM
  7. Search for text in multiple excel files
    By sc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2006, 09:45 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