+ Reply to Thread
Results 1 to 4 of 4

Find Particular name is numerous sheets

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 365
    Posts
    85

    Find Particular name is numerous sheets

    Hi,

    I have a workbook which contains about 60 sheets. I need to find a way of searching a particular person without having to go into each individual sheet and using the find function. Is there anyway I do this showing all the entries for that particular person.

    Any help is much appreciated


    Thanks

    Harry

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Find Particular name is numerous sheets

    Hi,

    In short no. One way or another you will need to 'look' at all sheets whether you do this manually or with a macro.

    Without seeing your workbook it's difficult to comment further, other than to say it's more than likely that you should reconsider your data layout and rather than have]ing 60 sheets have just one, with an additional column to keep the value of whatever currently distinguishes your separate sheets.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-14-2014
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Find Particular name is numerous sheets

    Hi Harry - When you click on Find, click on the Options>> button. There you can do a search within a workbook and say Find All. I'm not 100% sure if this is available in 2003 though but worked for me 2013.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Find Particular name is numerous sheets

    ...and just to clarify, Lisa is quite correct that you can 'show' all the names in the way she describes in the Find window.

    If you need to list them somewhere then you'll need some sort of macro.

+ 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] Running a macro over numerous sheets
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-06-2013, 10:36 AM
  2. Find related data from numerous sheets and get totals......
    By mthelm85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2012, 03:02 PM
  3. Match Name Numerous Sheets
    By Killer17 in forum Excel General
    Replies: 2
    Last Post: 02-03-2009, 08:25 AM
  4. Macro to format numerous sheets into one
    By mccrimmon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2007, 05:35 AM
  5. propogating cells with data from numerous sheets
    By G. Beard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2005, 07: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